manelson05
asked on
How do I change the SA password in GP dynamics
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?
Will this impact the ODBC conenction or any clients that were previous setup witht he old password?
You can't change the SA password from within GP.
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"-->"Mi crosoft 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.
1. Open the "SQL Server Enterprise Manager". This is usually under "Start"-->"Programs"-->"Mi
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
We have SRSS running to will this pass transfer over via SQL?
Thank you
mark
Thank you
mark
ASKER
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
Thanks again
mark
Mark, that's great - thanks!
-Victoria
-Victoria