Please enable Javascript to correctly display the contents on Dot Net Tricks!

Clear List of Recent SQL Server Connection From SQL Server Management Studio

  Author : Shailendra Chauhan
Posted On : 17 Nov 2012
Total Views : 121,353   
Updated On : 24 Sep 2016
 

While working with SQL Server, we connect to the different-different data server. As a result of this SSMS has a list of diffrenet SQL Server which we have used. 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. To resolve this issue, we should clear this server list from SSMS.

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.

Note

  1. Before removing above "mru.dat" or "SqlStudio.bin" file, please note down the exist or required SQL Server connections so that you can add these server on re-open of SSMS.

What do you think?

I hope you will enjoy these tricks while working with SQL Server. I would like to have feedback from my blog readers. Your valuable feedback, question, or comments about this article are always welcome.



Free Interview Books
 
COMMENTS (0)
12 AUG
NodeJS with Angular4 Development (Classroom)

11:00 AM to 12:30 PM IST (+5:30 GMT)

Know More
5 AUG
ASP.NET MVC with Angular4 Development (Online)

10:30 Am to 12:30 PM IST (+ 5:30 GMT)

Know More
3 AUG
ASP.NET Core with Angular4 Development (Online)

07:00 AM - 9:00 AM IST(+5:30 GMT)

Know More
29 JUL
Angular2 and Angular4 Development (Online)

08:00 AM - 10:00 AM IST(+5.30 GMT)

Know More
29 JUL
ASP.NET MVC with Angular4 Development (Classroom)

09:30 AM - 11:00 AM IST (+5:30GMT)

Know More
29 JUL
Xamarin Forms : Build Cross-platform Apps (Classroom)

09:00 AM - 11:00 AM IST(+5:30 GMT)

Know More
29 JUL
ASP.NET Core with Angular4 Development (Classroom)

11:00 AM to 12:30 PM IST (+5:30 GMT)

Know More
26 JUL
ASP.NET MVC with Angular4 Development (Online)

07:00 AM - 09:00 AM IST(+5.30 GMT)

Know More
26 JUL
ASP.NET MVC with Angular4 Development (Online)

07:00 AM - 09:00 AM IST(+5.30 GMT)

22 JUL
MEAN Stack 2 Development (Classroom)

04:00 PM - 05:30 PM IST(+5:30GMT)

20 JUL
Hadoop Development cum Administration (Online)

07:00 AM - 09:00 AM IST(+5:30 GMT)

17 JUL
NodeJS with Angular4 Development (Online)

08:00 PM - 09:30 PM IST(+5.30 GMT)

15 JUL
ASP.NET MVC with Angular4 Development (Online)

03:30 PM - 05:30 PM IST(+5.30 GMT)

1 JUL
ASP.NET MVC with Angular4 Development (Classroom)

08:00 AM - 09:30 AM IST

1 JUL
MEAN Stack 2 Development (Classroom)

11:00 AM - 12:30 PM IST(+5:30 GMT)

30 JUN
Xamarin Forms : Build Cross-platform Apps (Online)

09:30 PM - 11:00PM IST(+5:30GMT)

6 JUN
ASP.NET MVC with Angular4 Development (Online)

09:00 PM-11:00 PM IST(+5.30 GMT)

20 MAY
NodeJS with Angular4 Development (Classroom)

05:00 PM - 07:00 PM

2 MAY
ASP.NET Core Development (Online)

07:00 AM - 09:00 AM IST(+5.30 GMT)

BROWSE BY CATEGORY
 
 
LIKE US ON FACEBOOK
 
+