Error message while querying a linked server SQL database

Tags:
Linked servers
SQL Server 2000
SQL Server 2005
SQL Server database
SQL Server errors
We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the domain server name that was setup with the ODBC. The linked server has already been tested successfully. We also have a front-end application written in ASP that qould query the SQL database on the second server based on the domain server name mentioned earlier. This all worked perfectly, until the second server was upgraded to SQL Server 2005 and then relocated and given a new IP address. Now, the front-end application cannot query the SQL database on the second server. We are getting two error messages: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. or [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified This is definitely a false error because the dsn name exists and have been tested to work. The displayed error depends on how I reference the ODBC domain server name that I setup before. Do you know why this might be happening?

Answer Wiki

Thanks. We'll let you know when a new response is added.

The first thing to check would be to make sure that the two servers can still talk to each other. From the console of the first server see if you can ping the second server. If you can then see if you can telnet to port 1433 on that server. If you can check the DSN and make sure that it has the servers name and not an IP Address. Also check the client network utilities and make sure that there is no alias setup pointing to the old servers IP address.

Can you use Query Analyzer from the console of the SQL 2000 machine to log directly into the SQL 2005 server?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following