Msg 7314 + The OLE DB provider "SQLNCLI11"
- Minaz Amin
- Oct 29, 2015
- 1 min read
I was unable to run queries against another database table using link server. The query yell with the following error
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI11" for linked server "XXXXXX" does not contain the table ""XXXXX"."dbo"."XXXXX"". The table either does not exist or the current user does not have permissions on that table.
I checked the link server catalog and found the database is present. While checking the user which was defined as remote user does not have access to the database. Once I given the read/write permission on the database the query ran smoothly.
Comments