Multiple SQL Server Instances display in ODBC Server drop down

Question

I've encountered this problem a few times and don't seem to know why it's happening.  Basically when you configure and ODBC connection to either a SQL Server 2000 or 2005 instance when you go to specify a server name that server name appears twice in the selection box.  One will not work where as the other one will.  Any ideas on this problem?

Answer 1

Good Morning:
This forum is for technical questions related to the SQL Server protocols documented in the Open Specifications section of the MSDN Library.

There are several forums dedicated to discussion of SQL Server at the following URL:

http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17

Please post your question to the forums in the above mentioned URL.

---

Regards, Obaid Farooqi

Answer 2

I actually figured it out... the reason for the duplicate server names was there was an alias defined with the alias name the same as the servername.