March 26, 2009 at 9:06 am
Hi, I need to change the sa password on a 2 node SQL 2005 SP2 cluster. The sa password on file is not working. We have other logins with sa rights.
What are the steps to change the sa password when we do not know the existing one on a cluster?
March 27, 2009 at 12:12 am
sa is a SQL Server account; if you have users with Sysadmin rights you should be able to just go to properties and set it. I have to change sa passwords on few servers that way because I got servers handed to me and old DBA was no where in sight ... probably good for him/her (I did beat em silly for their setup LOL).
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 27, 2009 at 10:56 am
So changing it on one server is enough?
Cluster is set up as failover.
March 27, 2009 at 11:30 am
In SQL Server failover configuration in two nodes (Active-Passive) it is only one SQL Server even though you are using two computers. So when changing passwords on the SQL Server it is only one place need to be changed.
Unless you are running Active-Actice configuration ;-).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply