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.
[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?