Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

sa password reset

Posted on by 5

I need to reset the sa password as it was corrupted.

I followed one of the instructions in this forum to do the following:

You need to do this directly in SQL server management studio under the >Security>Logins.  Then Right click on 'sa', click properties, change the password and enter it again to verify.

and I can get all the way through the instructions - click OK.  But get an error that says

Change password failed for Login 'sa'.  An exception occurred while executing a Transact-SQL statement or batch

Cannot alter the login 'sa' because it does not exist or you do not have permission.

Help!

  • SavATree Profile Picture
    SavATree 5 on at
    RE: sa password reset

    Thanks folks - took me a while to find out how to get back to this screen but really appreciate the answers.  Turns out that you are correct, I didn't have the right level of security to reset the sa password.  But more importantly, it also turns out that I was just entering the wrong password when trying to sign on.  Might need a vacation ......   Thanks!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: sa password reset

    Altering the 'sa' password is not something just anyone can do.  You might be able to go thru the motions as your user ID when connected to SSMS but to actually change the password is reserved to SYSADMIN users.

    Just poking my nose into this one.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: sa password reset

    You will need to check your settings in your domain for security and make it is strong enough. Also make sure have not disabled the 'sa' account.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans