Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP Changing Password A...
Finance | Project Operations, Human Resources, ...
Unanswered

GP Changing Password After Upgrade - Failed for unknown reason

(0) ShareShare
ReportReport
Posted on by abutler1986 667

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:

pastedimage1615671722764v1.png

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

Categories:
Microsoft Dynamics GP
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

    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.

  • abutler1986 Profile Picture
    abutler1986 667 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

    pastedimage1615745354153v1.png

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

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

  • abutler1986 Profile Picture
    abutler1986 667 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

    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:

    pastedimage1615735048605v1.png

    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]

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

    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.

  • abutler1986 Profile Picture
    abutler1986 667 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

    Hi Richard,

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP Changing Password After Upgrade - Failed for unknown reason

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans