SQL Server Home
Connect to Server screen has duplicate instance names in Server name list
as Won't Fix
11/23/2010 12:40:04 PM
User(s) can reproduce this bug
When I try to connect to a server, the available server list has dublicates.
Please note SQL Server is 32-bit on X64 Windows 7 OS.
SQL Server Denali CTP 1
Tools (SSMS, Agent, Profiler, Migration, etc.)
Windows 7 Ultimate
Operating System Language
Steps to Reproduce
Click on Connect in Object Explorer window
Open Server Name list in Connect to Server screen
I have a long list of repeated default instance, existing SQL2008R2 instance and SQL2011 CTP1 instance
List of instances without a repeat in the dropdown list
to post a comment.
Please enter a comment.
on 12/7/2010 at 9:19 AM
Greetings from the SQL Server Manageability team.
Thanks for writing in to Microsoft. We greatly value your feedback. We understand your problem, and how fixing this could improve productivity.
However, given the work that would be involved in implementing this work, and triaging against our current set of deliverables, we do not think, we would be able to get to this in the near future.
Also you would have the opportunity (should you have the need to do so) to manually delete the duplicates.
Having said that, we value your suggestions, and would like to assure you that, we would keep these ideas in mind, when we do revisit this feature in the future.
Thanks again for providing feedback and making SQL Server the greatest Database server.
on 11/24/2010 at 8:26 AM
This is typically due to connecting to the server with different credentials or different auth methods.
The good news: we will have access to the MRU list in Denali, at least according to this Connect item:
to post a workaround.
Please enter a workaround.
on 8/7/2012 at 5:25 PM
You could follow the blog entry http://blogs.msdn.com/b/managingsql/archive/2011/07/13/deleting-old-server-names-from-quot-connect-to-server-quot-dialog-in-ssms.aspx
Sethu Srinivasan [MSFT]
© 2013 Microsoft