CODEWITHSUNDEEP
sql-server-2005
ScottyDont
ScottyDont

Reputation: 1207

Remove entries from Connect to Server dialog

In SSMSE 2005, once you successfully connect to a SQL Server instance, that server appears in the drop down box in the Connect To Server dialog box.

Does anyone know how to remove an entry from this list?

I haven't found anything in the registry or in any local files.

Upvotes: 0

Views: 980

Answers (2)

C_W
C_W

Reputation: 11

For Windows 7:

For SqlExpress 2008 front-end using a SQL Server 2005 back-end delete the following file:

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

This file will get recreated once you restart SQL Server

Upvotes: 1

MBoy
MBoy

Reputation: 704

On Vista delete:

C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

On XP delete: 

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

Unfortunately this removes all entries. I haven't found a way to remove a single entry yet.

If the above doesn't work I have heard mention of:

C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat

or

C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat

but cannot test as I do not have the folder.

An article on the SQL Server 2005 Management and Administration Tools:

http://www.informit.com/articles/article.aspx?p=680822&seqNum=2

Upvotes: 1

Related Questions