Home > IT Answers > SQL Server > Error message while querying a linked server SQL database
SQL Server Ask the Experts
2,585 pts.
 Error message while querying a linked server SQL database
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?

Software/Hardware used:
ASKED: October 23, 2008  6:37 PM
UPDATED: October 23, 2008  10:52 PM
RELATED QUESTIONS
Answer Wiki:
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?
Last Wiki Answer Submitted:  October 23, 2008  10:52 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _