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 - 2012-04-19 : 17:14:09
|
I have 2 instances of SQL 2008. We login to SSMS with Windows Authenication. Our network logins are managed through Active Directory. The systems Admin has dictated that we change our Administrator password. Therefore I need to change the Administrator login in SSMS.I assume I will change the Administrator password in SSMS. Then when they change the password for the server, SSMS should open as usual.It seems simple but I have been a DBA for less than a year and I don't want anything coming up that I won't be prepared for.I have some 2005 instances as well. Is the process any different?And finally, is there a command that will show me the password to any/all logins in SSMS?Thanks, in advance.10Dawg |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|