Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / DynamicsGP10.0 SA pass...
Microsoft Dynamics GP (Archived)

DynamicsGP10.0 SA password reset

(0) ShareShare
ReportReport
Posted on by Kevmster_k 100

All,

 

I am trying to reset the SA password for the databases and SA user account associated with my Dynamics GP10.0 platform.  I can change it within SQL system manager, but when i try to log into GP10 with the newly created password it fails. If i put the old SA password back in within SQL system manager, the account now works again.

 

 Is there somewhere in the application that i have to change the SA user password other than the normal  Tools -> Setup -> System -> Users-> ?? When i look at the SA account to try and change the password, all fields are greyed out. Is there anything else that would keep the SA account within GP from changing when i change it within SQL system manager?

 

appreciate any nudges in the right direction.

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: DynamicsGP10.0 SA password reset

    Hi,

    Also check any Maintenance Plans, SQL Jobs, and connectivity to SQL (ssrs, ssas etc.) as they might have been configured with the 'sa' user and hence might not execute.  The connection settings will have to be updated with new password as necessary.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: DynamicsGP10.0 SA password reset

    Hi,

    You may have to reconfigure your GP ODBC DSN, which usually is not needed.

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: DynamicsGP10.0 SA password reset

    Hi,

    The sa password is attached to SQL and you will have to change the password within SQL.

    1. Open the "SQL Server Enterprise Manager". This is usually under "Start"-->"Programs"-->"Microsoft SQL Server".

    2. Navigate to the "Logins" object under the "Security" folder on the SQL Server you wish to administer. Then, right click on the 'sa' account and select "Properties".

    3. Now, enter a new password in the "Password" field under the "Authentication" options.

     

     

  • mpolino Profile Picture
    mpolino on at
    Re: DynamicsGP10.0 SA password reset

     It sounds like you are changing it in the right place. You can't change the SA password from within GP.

     Mark

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans