SQL Server Error: Invalid use of schema or catalog for OLE DB provider "SQLNCLI11" for linked server "*". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

SQL Server Error:

Recently I was building a new database infrastructure on SQL Server 2012 to run a  third party application called Relativity by kCura and received below error on application side. After I resolve this error, just thought to share on blog so that it can help others.

Invalid use of schema or catalog for OLE DB provider "SQLNCLI11" for linked server "*". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

Resolution:

Connect to the SQL Server via SSMS (SQL Server Management Studio) and go to
Server Node --> Server Object --> Linked Servers --> Provider and right click on SQLNCLI11, go to Properties and uncheck the “Level zero only” and click OK and restart SQL Server Service.

The above steps will resolve this error.

Thanks!