[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Error 7202 - Could not find server in sys.servers
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Error 7202 - Could not find server in sys.servers.


Applies to: SQL Server 2008 R2, Windows Server 2012.
 

Problem Description.
 

One of the developers at my organization was working on a test environment and he was trying to execute a remote query to an Oracle server using an OPENQUERY that makes reference to a linked server, but the developer received the following error when he executed the OPENQUERY:

Error: 7202, Severity: 11, State: 2
Could not find server 'XXXX' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.


Cause


The linked server existed on the SQL Server instance of the production environment but didn't exist on the SQL Server instance assigned to the test environment.


Solution
 

The solution was to configure the Oracle client on the SQL Server instance of the test environment to be able to connect to the Oracle database server, then configure an ODBC data source, and finally use the ODBC DSN to create the linked server with the same name used in the production environment.



 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.