Check how much technoledge do you have??
Enjoy The world of "Technoledge".
This blog is all about Technology.
Latest Tech-news, Tips & Tricks, Fun Stuffs for Internet, Computer, Site etc.
If you have something more technoledge, please share it with others by posting here.
If any one want to post an article on this site or he want authors rights please contact me at email@example.com.
Friday, July 29, 2011
Clearing Sql Management Studio Saved Passwords
"I've recently used our company's spare laptop (that has a general user set up) while mine was being repaired. I've checked the "remember password" option in SQL Management studio when logging in to the database. I need to clear the login and password information that i have used to prevent the next person that will use the laptop from using my login names and passwords. How can I do this?"
Do you have similar question?
Then Here is the Solution :
Solution can be for two scenarios :
Scenario 1: If u wanna clear only password of 1 UserID: First go to : "%AppData%\Microsoft\Microsoft SQL Server\\Tools\Shell\" Now open : "SqlStudio.bin" in Notepad / WordPad Search for : "Password" and delete the encrypted password Check : UserID mentioned aside.
Enjoy... your pasword of that userid has been reset now.
If u wanna clear all passwords:
First go to : "%AppData%\Microsoft\Microsoft SQL Server\\Tools\Shell\"
Now delete : "SqlStudio.bin"
Enjoy... your all paswords has been cleared from the sql cache.