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

Ekrem Önsoy

5 years ago

“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