Post reply

Changing sa password

  • July 3, 2008 at 6:38 am

    #123069

    hi all.

    am about to change the sa password on a production server, but i need to make sure of one thing should i fix any thing after the new password or it dosent matter.

    thanks

    ..>>..

    MobashA

  • July 3, 2008 at 7:03 am

    #837807

    You need to find if any application is using this or not.

    If yes, its not best practice and you have to change the connection string

  • July 3, 2008 at 7:20 am

    #837821

    yes i have already check this, and i dont have any application that uses sa account.

    ..>>..

    MobashA

  • July 3, 2008 at 7:48 am

    #837848

    [font="Verdana"]If possible check DSN also, sometimes this may be used...

    If sa login is used nowhere, then you are safe to reset the password.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • July 3, 2008 at 7:53 am

    #837852

    Create a New User and assign it as sysadmin. Or Add your Windows ID in sysadmin Role. After you change the Original SA PAssword, you can undo the user Priviliges.

    Maninder
    www.dbanation.com

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply