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

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

18 Mar 2024
Intermediate
138K Views
4 min read

Clear List of Recent SQL Server Connection From SQL Server Management Studio: An Overview

While working with SQL Server, we connect to the different data servers. As a result, SSMS has a list of different SQL servers we have used. Sometimes this list creates confusion and we try to make the connection to SQL Server which does not exist or does not have access to. To resolve this issue, we should clear this server list from SSMS.

Read More: SQL Server Interview Questions and Answers

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 the above locations, search this file in the 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.

Read More: Basics of SQL Commands

Clear recent connection list from SQL Server 2005

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 the above locations then search this file in the 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

Note

  1. Before removing the above "mru.dat" or "SqlStudio.bin" file, please note down the existing or required SQL Server connections so that you can add this server on the 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. If you want to gain a practical understanding, you can enroll in our SQL Server Course.

Do You Know?

.NET is gaining popularity day by day, especially after the release of .NET 8. .NET 8 is not only a framework version but much more than that. It redefines the way software applications are built and deployed, enabling developers to meet the evolving demands of modern computing.

Therefore, if you want to upskill yourselves and stand out from others consider our following training programs on .NET.

Take our free sqlserver skill challenge to evaluate your skill

In less than 5 minutes, with our skill challenge, you can identify your knowledge gaps and strengths in a given skill.

GET CHALLENGE

Share Article
Batches Schedule
About Author
Shailendra Chauhan (Microsoft MVP, Founder & CEO at Scholarhat by DotNetTricks)

Shailendra Chauhan is the Founder and CEO at ScholarHat by DotNetTricks which is a brand when it comes to e-Learning. He provides training and consultation over an array of technologies like Cloud, .NET, Angular, React, Node, Microservices, Containers and Mobile Apps development. He has been awarded Microsoft MVP 8th time in a row (2016-2023). He has changed many lives with his writings and unique training programs. He has a number of most sought-after books to his name which has helped job aspirants in cracking tough interviews with ease.
Accept cookies & close this