In MS SQL Server Management Studio, I saved a connection long ago that still works.  I checked the box to save the password, and it worked.  However, I now have no idea what the password was and want to use the connection with excel or vb or whatever.  Management Studio has obviously stored the pwd somewhere (surely it is encrypted), but where is it and is there someway to use it with the other programs?

Please check whether you can use windows authentication to log in with local admin user? If you can, then you can set new password.

If it is sql server authentication then u can reset your password.You can go to Server-->security-->Logins-->user(reset the password).

Thanks.  I could do that, but the userid is used by some other programs that I would thus break if I changed the password.  I can use windows authentication and log in the local admin user.

HI,

I don't think there is a way to know the password using SQL Server. if you want to script out the login you can do this by following the link below

http://support.microsoft.com/kb/918992/en-nz?wa=wsignin1.0

when the SQL server scripts out the logins the passwords will encrypted, So there is no way of finding the password unless you change it or find the current one.

Hope this helps

Thanks

Bhanu

• Edited by bhanu_nz 8 hours 22 minutes ago

 I now have no idea what the password was

If you don't know the password, then we can't tell you it, and SSMS stores PWD in an encrypted way, you can't get in clear word