i need to change the 'sa' password and it can be done within SQL. what i need to know is that will i have to manually go or via remotely change the ODBC DSN Sql authentication password on every single machine because we have configured SQL Server Authentication in ODBC on every user. or is there some other simple way/solution?
We have 300+ GP users located on 4 different locations and all are connected locally on same network, so its very hectic to do it manually on every machine
Also please tell me the steps/measures to follow before changing 'sa' password Thanks and Kind Regards,
ODBC does not really "save" the password you fill, it is only uses the password to verify the connection upon the creation process, therefore you will not be required to go on all machines and reconfigure the ODBC if the "sa" password was changed.
*** If my answer resolved you issue, please verify the answer to make it easy for other users who has the same case ***
Mohammad R. Daoud MVP-MCT
Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx
Just be sure that none of the services loaded are using the sa user id and password. It should not happen but I have seen some shops do this.
And Mohammed is correct, you do not need to change anything in the ODBC or in GP for that matter.
Richard L. Whaley Author, Publisher, Consultant
Enhancing your Dynamics Knowledge!
Good point Richard,
I see it a lot in small shops where sa is the service account for everything.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics