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?
views:
2531answers:
7
+3
A:
Delete:
C:\Documents and Settings\%Your Username%\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat"
BobbyShaftoe
2008-12-08 14:18:42
Sorry but this is wrong
abatishchev
2010-01-28 15:39:31
@abatishchev, so I think you're wrong. The fact that two others agree with me and one actually used this method make me question the correctness of your statement.
BobbyShaftoe
2010-01-28 16:47:03
I have installed MSSSMS2008E under Windows 7 and even have not mru.data neither in %AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell not in %LocalAppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell. But Robin Luiten's answer helps under both Windows XP and Windows 7. As far as I see our controversy takes place often: http://tinyurl.com/ybc8x8p
abatishchev
2010-01-29 09:16:51
This worked in Windows XP for me
Brian
2010-03-09 13:17:21
This works in Server 2003
jacko
2010-04-12 09:23:58
+16
A:
SQL Server Management Studio 2008 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
SQL Server Management Studio 2005 delete the file – same as above answer but the Vista path. C:\Users\%username%\AppData\Roaming \Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
These are profile paths for Vista.
Robin Luiten
2009-08-03 04:43:57
"%AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin"
abatishchev
2009-10-21 08:14:31
The mru file may exist in Vista/Win7, but for XP, I never found the mru file. I instead followed the above comment (renamed but did not delete) and Sql Manager happily recreated the SqlStudio.bin file next time I launched it, so the above comment is correct for XP users.
Bruce
2010-03-17 18:01:53
+1 Thanks! Removing `C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin` worked for me in Win7.
Ismail
2010-07-22 05:24:02
A:
I successfully did what abatishchev said, I renamed "%AppData%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin" and all the SSMS 2008 Logins & PWs where reset to nothing. I never did find a mru.dat file.
John
2010-02-03 15:34:14
A:
In XP, the .mru.dat file is in C:\Documents and Settings\Name\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM
However, removing it won't do anything.
To remove the list in XP, cut the sqlstudio bin file from C:\Documents and Settings\Name\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell and paste it on your desktop.
Try SQL
If it has worked, then delete the sqlstudio bin file from desktop.
Easy :)
Dave
2010-05-28 09:56:10