235
Any user access welcome login screen get previous error massage and can not continue, but the user has Sysadmin role in SQL Server passed with no error.
I had checked kb/919345, but no one solved my case, Is there any suggestion ?
*This post is locked for comments
Please note if you are using GP 2013, when you create the profile and tick any of the 'advanced sql server options' the profile credentials has to be the same as in Active Directory. It has to be the same user id as well as password. Passwords are also case sensitive.
Hi Mounir,
When you create a new user in GP. You need to give him access to the company and assign him a security role for that user. The GP will take care of the roles based on the security Role ID's selected for the user. e.g "AR Clerk". Based on the roles assigned, the new user will be allowed to perform certain tasks.
Note: You need not go and change the user role in the SQL.
You have to login to GP as SA.
Create new users by providing user name and password.
After this try to login to GP with the newly created user details.
When you create from GP roles in SQL will be assigned automatically. Don't change them.
After The user had created in GP, I changed the password from application by SA, but the user can not pass login screen, he pass only if I let him a Sysadmin in SQl
Mounir,
Dynamics GP Users must be created in GP, not just SQL. GP will create the SQL Accounts as part of the user creation process. Go to Microsoft Dynamics GP > Tools > Setup > System > Users to add users. Here is a link to a simple overview of this multi-step process.
kbase.dyntools.com/.../how-to-create-a-new-user-in-dynamics-gp
Thanks Harry, it's working with SA user, but not working with a user has public role only in SQL
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,356
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
