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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to change the password of SSMS login?

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

Posted - 2012-04-19 : 17:42:20
If you are using Windows authentication, then there is nothing to change in SSMS regarding passwords. You would do it at the Windows layer.

Now if the service account password is being changed, then that's another story. Let us know what exactly is being changed and if it affects any services.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -