Duplicate Server Name When Creating ODBC -- sql server odbc

Netwerktek
11/18/2004 11:30:15 AM

When creating a SQL Server ODBC connection via Data Source applet on a WXP
workstation, when clicking the drop down menu to select the server, two
instances of the same server appear. We recently migrated our SQL server to
new hardware. Turned off the old server and gave the new server the same name
and IP. Also renamed the instance of SQL on the server to the old name. I am
sure this is the cause but not sure how to remove the duplicate entry on the
workstation. We are only seeing this on one workstation? Thanks for your
feedback.
--

Netwerktek
11/19/2004 1:49:03 PM

That did it. Thank you very much!

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
11/19/2004 6:28:23 PM

On this computer do the following:

Go to Start - Run
Type in cliconfg and click OK
This will start the Client Network Utility
Go to the Alias tab
There should be an alias defined for this server
Delete the alias. this the where the second entry is coming from.

(Before deleting note the properties. You may need to add it back if
connections fail after deleting it.)

Rand
This posting is provided "as is" with no warranties and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Duplicate Server Name When Creating ODBC