DynamicsGP10.0 SA password reset

• 10-22-2008 1:11 PM

  Kevmster_k Joined on 10-22-2008 Posts 2

  DynamicsGP10.0 SA password reset Reply Contact 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.

  Tags: Dynamics GP, GP, SQL 2005, Passwords, GP 10

• 10-22-2008 3:34 PM

  In reply to

  mpolino Joined on 04-09-2007 Orlando, FL Posts 16	Re: DynamicsGP10.0 SA password reset Reply Contact  It sounds like you are changing it in the right place. You can't change the SA password from within GP.  Mark

• 10-22-2008 3:51 PM

  In reply to

  Hugh Pearson CMA Joined on 03-12-2008 Posts 8

  Re: DynamicsGP10.0 SA password reset Reply Contact 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.

• 10-22-2008 11:03 PM

  In reply to

  Vaidy Joined on 06-11-2008 India Posts 16	Re: DynamicsGP10.0 SA password reset Reply Contact Hi, You may have to reconfigure your GP ODBC DSN, which usually is not needed.   Thanks Vaidy Mohan www.vaidy-dyngp.com

• 10-23-2008 6:26 AM

  In reply to

  Hugh Pearson CMA Joined on 03-12-2008 Posts 8	Re: DynamicsGP10.0 SA password reset Reply Contact 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.