An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.

Ekrem Önsoy December 24, 2018 MSSQL

“An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.”

I received this error message when I ran a command similar to the following using a Linked Server:

SELECT * FROM LinkedServer.MyDatabase..MyTable

1	SELECT * FROM LinkedServer.MyDatabase..MyTable

Make sure that you use Fully Qualified Name in the queries you use in Linked Server. The draft of this is as follows:

[Linked Server Name].[Database Name].[Schema Name].[Object Name]

Example:

SELECT * FROM LinkedServer.MyDatabase.MySchema.MyTable

1	SELECT * FROM LinkedServer.MyDatabase.MySchema.MyTable

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux