SQL Server - Clear list of server names on SQL Server Management Studio

22 October,2012 by Jack Vamvas

Sometimes there is a requirement to clear down the Server Name items on the SQL Server Management Studio Connect to Server GUI. 

 The method used is slightly different for versions of SQL Server Management Studio. These are undocumented processes and there is guarantee they are available in future versions. It’s unclear what other data is deleted.


 How to clear the list

Shut down all SSMS instances on the server
Delete/Rename the file


For SQL 2005, delete the file:

C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

For SQL 2008, the file location, format and name changed:

C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

For Windows 7, it's in the following:

SQL 2005:
C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

SQL 2008:
C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

 Related Posts

SQL Server - Open SSMS on the Command Line

SQL Server – Open SSMS without the splash screen graphic

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL Server - Clear list of server names on SQL Server Management Studio

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer