Post reply

changing sa password

  • February 21, 2002 at 10:11 am

    #57619

    I am running Sql 2000 in Active/Active mode. I need to change the sa password. Is that as simple as going into Enterprise Mgr and changing the password like any other user and do this in both instances of SQL?

    Thanks,

    Tracy

  • February 21, 2002 at 10:16 am

    #424258

    Yes, that would be one way.

  • February 21, 2002 at 10:22 am

    #424260

    Thanks...that was easy.

  • February 21, 2002 at 10:22 am

    #424259

    Yes. When running Active/Active, you have 2 SQL Servers. there is, of course, a shared virtual SQL Server as well, but the two instances "pose" as this virtual.

    change them individually. If you are concerned about time, script them both.

    Steve Jones

    steve@dkranch.net

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

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