forum.venkateswarlu.net
      Register      Login
How to Clear List of Recent SQL Server Connection From SQL Server Management Studio?

1 replies to this topic

Aisha Bobby #1
Member
96 Points
 Posted on 21 Aug 2013 11:22 AM IST

How to Clear List of Recent SQL Server Connection From SQL Server Management Studio?

While working with SQL Server, we connect to the different-different data server.Sometimes this list create confusion and we can try to make the connection to SQL Server which does not exist or we does not have access to it. How to resolve this issue?

 
SQL Server     980 views     Reply to this topic
Jahnavi N #2
Member
164 Points
 Replied on 21 Aug 2013 09:34 PM IST
Clear recent connection list from SQL Server 2005

First of all make sure that the SSMS is closed. Now remove or rename the file "mru.dat" from the location

"C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat" or
"C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat"

If you are not able to find the file "mru.dat" at above locations then search this file in system drive and remove or rename it.After removing or renaming, launch the SSMS and you will not see any of the most recently used servers in the list.

Clear recent connection list from SQL Server 2008 or 2008r2

First of all make sure that the SSMS is closed. Now remove or rename the file "mru.dat" from the location

"C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin" or
"C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\SqlStudio.bin"

If you are not able to find the file "SqlStudio.bin" at above locations then search this file in system drive and remove or rename it.After removing or renaming, launch the SSMS and you will not see any of the most recently used servers in the list.
 
Reply to this topic