Changing password of 'sa' in GP 2010

This question is answered

Dear All,

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,

Asher

Verified Answer
  • Hello Asher,

    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 ***

    Regards,

     

    Mohammad R. Daoud MVP-MCT

    Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx

All Replies
  • Hello Asher,

    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 ***

    Regards,

     

    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

    http://www.AccoladePublications.com

    Enhancing your Dynamics Knowledge!

  • Good point Richard,

    I see it a lot in small shops where sa is the service account for everything.

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net