Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
10Dawg
Starting Member
46 Posts |
 Posted - 2011-07-21 : 09:17:30
|
| I have both Sql 2005 & 2008 that login with Windows credentials. Yesterday the SysAdmin decided to change the passwords of all the servers. So I need to change the Administrator login pw in sql. Can I just change the pw? If so, how? Or do I just blow the current Admin login away and create a new one? Is there any other considerations I need to know before i do this?10Dawg |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-21 : 09:59:24
|
In my humble opinion:If your SysAdmin decides and tells you to change the passwords of all the servers then HE should be your first and main contact person and not a public forum.Excuse me if I am wrong with that but that's what I would do.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
10Dawg
Starting Member
46 Posts |
Posted - 2011-07-21 : 10:56:47
|
| Let me rephrase, if a password to the server where a slq instance resides, gets changed, what do I have to do as a DBA to ensure the SSMS continues to open with Windows credentials? In both, sql 2005 & 2008.10Dawg |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-21 : 11:18:27
|
| Nothing at all. But servers don't have passwords. Logins do.If the Service Account password was changed, then it will need to be changed in the services applet to.As for being able to connect, you don't need to do anything. |
|
|
|
|
|
|
Change Password