GP Changing Password After Upgrade - Failed for unknown reason

(0) Share

Report

Posted on by abutler1986

677

Hi All,

I have had this a few times and typically with smaller upgrades I get around the problem by deleting the users and re-creating however I am dealing with a much larger upgrade with over 100 users so.. was hoping for a better way to go about this.

So for the test upgrade on the new server, after I restore the databases and say run the upgrade to the last step of GP18.3, i then run the SQL Login Capture script against the old sql server then run the results against the new sql server and it creates the logins fine, I then typically change the password for each one (which is equally as long..) then they login fine after i also run the grant script for good measure.

However after I do the live upgrade so just restoring a database this time and the logins SQL are of course already present, upon sucesful upgrade I then go to change the users password then when I login as that user I get the following:

Any ideas on the correct process or a nice quick way around this?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (0)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Is this server part of a new domain with more stringent policy restrictions? Try longer passwords with special characters?

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

Hi Richard,

No same domain just a new server. I have tried longer passwords still get the same message.

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

Like (0)

Report

Are you at least able to login as 'sa'? If you go into SSMS is it set for SQL Authentication? When you check the users is their Status set to Enabled? Under Security->Logins->Right click on User->Properties->Status.

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

I can login as 'sa' fine and the user is enabled.

What I find weird is, when I go to change the test users password, it comes up with the usual box saying you must change your password but it first pops this box up:

Also, i have checked the event viewer and it appears to be doing something more odd:

Login failed for user '***'. Reason: The password of the account must be changed. [CLIENT: 10.10.200.26]

Login failed for user '***'. Reason: Failed to open the explicitly specified database '***'. [CLIENT: 10.10.208.60]

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

Like (0)

Report

Under Security->Logins in SSMS right click on the user and then click Properties. Please send screenshot of what you see under General.

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

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

Like (1)

Report

Try unclicking Enforce Password Policy. Change password in GP on the server as 'sa' for this user and then try logging in as this user on the server.

Was this reply helpful? Yes No