web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Changed "sa"...
Microsoft Dynamics GP (Archived)

Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

(0) ShareShare
ReportReport
Posted on by Mike_Normal 480

I changed the sa password in SQL Server Management Studio. After that I couldn’t log into Dynamics GP as “sa” user. Went back to SQL SMS and entered the previous password. Then I could log into GP as “sa” user. I did this several times to confirm that I wasn’t typing in the wrong password.  Apparently GP is retaining the sa password from the original installation no matter what changes are made in SQL SMS. In the GP User Setup dialog, the sa USER ID choice does not allow password changes.

 

So how do I change the sa password to be able to log into both GP and SQL? I did a search and came up with nothing. Found some posts stated that changing the sa password in SQL SMS would flow though to GP. That doesn't seem to be the case with either my installation or GP2013.

*This post is locked for comments

I have the same question (0)
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Mike,

    That does not sound right. 'sa' is treated differently by GP since it is a special SQL login and changing it in SQL should work. I have never seen this not work and just tested it with GP 2013 to double check - changed the password in SQL, then logged into GP 2013 using the new 'sa' password. No problems.

    Is it possible that you are changing the 'sa' password in a different instance of SQL than the one GP is using?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Victoria is correct. The password for 'sa' is not hashed like all other passwords are. Could the CAP locks button be on? Try something simple like '123' and then try the textual version to confirm.

  • Douglas Karel Profile Picture
    Douglas Karel 2,140 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Could it be the ODBC connection used for GP is configured to to use sa to connect to the SQL?   That might have the old password and can not connect.

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Thanks for the quick replies. Yes, I am using the correct instance of SQL and have tried a simple numerical password.

    How do I reconfigure the ODBC connection? Should it be using the DYNSA account?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Changing to DYNSA is not the thing to do because only the 'sa' password is passed unhashed. What SQL client are you using for this DSN? Is it SQL Server or SQL Native client. You need to use the 32 bit ODBC administrator and use a System DSN then try different versions of the cleint. You will find this in the Windows\SysWOW64 folder. The file name is ODBCAD32.exe

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    The ODBC connection does not actually store the login or password, so that can't be it.

    Is it possible that you are logging into SSMS with a login that does not have enough permissions to change the 'sa' password? So it might not be giving you an error, but the password is not actually updating in SQL? Can you try logging in there with the 'sa' login? Change the password, then disconnect / log out. Log in again as 'sa' - only the new password should work. If that is the case, it should also now work in GP.

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    I change the password in SSMS, then log out. Then log in again to make sure I have a good password for sa on SSMS. Then I try logging in to GP 2013 and the new sa password doesn't work. Then I go back to SSMS, change the sa password back to the one that works on GP 2013, and log out of SSMS. When I then try logging in to GP with the old sa password, I can get in. Seem like GP is holding on to the original sa password.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    Mike,

    It feels like there is something else going on. As an additional test, can you try this:

    - change the 'sa' password in SQL

    - try logging into GP with the OLD 'sa' password

    If that works, then GP is not pointing to the same SQL instance or you have some kind of customization/modification that is causing this not be work properly. The latter seems unlikely, but I suppose it is possible.

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    I'll try that Victoria - hadn't thought of doing that test. Back to you in about an hour or so due to meetings.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Changed "sa" password in SQL SMS, now can't use "sa" in GP 2013

    You mention that you are using GP 2013. When GP 2013 was installed did you select to use the default name of DYNAMICS or did you choose another name and perhaps have more than one DYNAMICS system database? I know we are a few days past April 1st, but perhaps your IT staff is playing an April Fool's joke and one database was created using one 'sa' password and another one is using another 'sa' password. If you log into GP 2013 and change the 'sa' password within GP does that work?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans