Category: SQL SQL Server

How to remove SQL Server name from drop down in management studio

In SQL Server 2008/2005 Management Studio, during the login process there is an input text box called “Server Name”. This is a drop-down which stores a history of servers that you have previously connected to.

This article shows how to remove a server from the drop down history

  • Close the Management Studio Application (SSMS)
  • Delete relevant file as follows:

For SQL 2005:

C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server90ToolsShellmru.dat

For SQL 2008:

C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin
  • Reopen Management studio.

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: