Post reply

reset sa password

  • October 18, 2013 at 12:28 pm

    #284731

    We have a SQL server that using mixed mode login.

    I see the sa account was disabled. and we forgot the password.

    Because we no longer used it.

    We have an older application that used to connect with sa account.

    We would remove the old application, but it asked a bout the sa account to remove the application.

    Is it safe that we enable the sa account to reset the password, will it affect other databases on the server?

    Does it mean when it is disabled that means no current application is using it, and no one can connect to use it, so it is safe?

    THanks

  • October 18, 2013 at 6:06 pm

    #1659871

    When a login is disabled, sa or otherwise, it can't be used to log into the system.

    enabling it to change the password won't do anything to the server, however if an application is trying to log in with "sa", it will have a chance to do so after you enable it.

  • October 21, 2013 at 10:31 am

    #1660195

    Thanks, that helps.

Viewing 3 posts - 1 through 3 (of 3 total)

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