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