How do I change the SA password in GP dynamics

manelson05
manelson05 used Ask the Experts™
on
I need to change the SA password in GP dynamics 10, I will also need to update teh SQL password one this has been completed.

Will this impact the ODBC conenction or any clients that were previous setup witht he old password?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
You can't change the SA password from within GP.

Commented:
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.

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.
Owner / Dynamics GP Consultant
Commented:
There is no Dynamics GP 'SA' user - SA is only a SQL user and you can only change the password in SQL.  

The ODBC connection does not actually store any passwords, any password you enter is only used to connect to the server initially during the connection creation, so changing the SA password should not have any impact on that.  

Typically the issues we have seen after changing the SQL SA password are if:
- any services are set to use the SA account
- any SQL jobs are set to use the SA account
- the SA password is hardcoded into any applications or custom code/reports (this will not be the case for anything out of the box in GP)

Hope that helps
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Sa password is changed only in SQL, enter security, logins.
I will not afect odbc, because it is not stored

Is is necesary to check if vba customs, reports, packages or jobs, had used its password, because they wont work.

Author

Commented:
We have SRSS running to will this pass transfer over via SQL?

Thank you

mark

Author

Commented:
Thank you for your help. It is exciting to work with you as I just started reading your book I got from PACT online.

Thanks again

mark
Victoria YudinOwner / Dynamics GP Consultant

Commented:
Mark, that's great - thanks!  
-Victoria

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial