A Save operation on table 'SY_Users_MSTR' (45).

(0) Share

Report

Posted on by Sunneil Chaudhary

334

Hi,

When I am creating a user in Dynamics GP standard User Setup window(no customization). It gives me following error in both scenario whether i give complex or simple password.

7608.User-Creation-Issue2.png

I clear the field and lookup the newly created user and tab then i get following error... I checked sql but user is not created automatically.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Check the below link

http://support.microsoft.com/kb/919348

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sunneil,

Please make sure the ODBC contain the server name\ipaddress to connect the database should be same.

both Server side & client side should be same

e.g: server has server name then client should be server name & server has ipaddress then client should be ipaddress.

if it differs password conflict with above error occur.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi pragadees,

Please make sure the link you are provided is correct or not. since the error snap and KB article are different.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (1)

Report
Copy link

Link copied!

Open SSMS(SQL server management studio) and connect to your GP SQL server instance and the expand security-->logins. Now verify the user which you have tried to create in GP is available or not. If yes, then right-click the user id and click delete. Then go to GP user setup window and create the new user id.

Hope this helps!!!

Was this reply helpful? Yes No
Sunneil Chaudhary 334 on at

Like (0)

Report
Copy link

Link copied!

Dear Natarajan,

I have checked odbc connection and it is correct as GP is connecting and all other windows are working perfect and hitting the tables in corresponding database. User is created in GP in stead of throwing error but as I had mentioned it does not create user in SQL.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

You are logged into GP as 'sa', correct? Make sure this user account does not already exist in SQL for both SQL and on none of your databases, including DYNAMICS.

Was this reply helpful? Yes No
Sunneil Chaudhary 334 on at

Like (0)

Report
Copy link

Link copied!

Yes I am logged in as 'sa'. User does not exist either in SQL or any databases, as tried creating many users with different names and getting same error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sunneil,

Any user already present in Dynamics & Company Database?

Number of users are equal in both database?

Was this reply helpful? Yes No
Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report
Copy link

Link copied!

Have you verified that the sa account has the proper sysadmin roles in SSMS? Can you try using the DYNSA account?

Kirk

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Was the DYNAMICS database or any of the company databases copied from another server? If so make sure this account does not exist in SQL or any of the databases first using SSMS. Once it is clear, try to add the account using GP. Also, try not to use the domain name as the user ID in GP. So if your user domain name is mydomain\myuser, make the name in GP anything other than myuser.

Was this reply helpful? Yes No