Saturday, February 25, 2012

"Connect Object Explorer" issue

HI All,

When I connect to a remote database server my IP gets stored in the Object Explorer connection wizard. How do u ensure that once the server is disconnected you have to reenter the server IP again.

It also shows the username as soon as i enter the server name. I don't want this to happen. Please help.

A SQL Server MVP had the same question not too long ago. We found him an answer and he posted it on this blog:
http://devcow.com:80/blogs/adnrg/archive/2006/09/08/Clear_SQL_Server_2005_Management_Studio_recent_servers_drop_down_list.aspx

Basically, there is no way to clear it out through the UI. You have to delete the following file:
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

No comments:

Post a Comment