June 20, 2014 at 5:30 pm
We are getting this error message when attempting to connect a linked server to an ODBC data source logged in with SQL authentication:
OLE DB provider "SQLNCLI10" for linked server "AT-LINKED" returned message "Deferred prepare could not be completed.".
Msg 7303, Level 16, State 1, Procedure JCJob, Line 3
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CE_LINKED".
Msg 7399, Level 16, State 1, Procedure JCJob, Line 3
The OLE DB provider "MSDASQL" for linked server "CE_LINKED" reported an error. Authentication failed.
OLE DB provider "MSDASQL" for linked server "CE_LINKED" returned message "Error 20000002: An error has occured while opening a file, Error 00000005: Access is denied. , file "E:\GDr\Con\Da\X\xxxxxx.dat"".
OLE DB provider "MSDASQL" for linked server "CE_LINKED" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
When we login to the same linked server with Windows authentication, there is no error and the connection works perfect.
Any advice on how to resolve ?
June 21, 2014 at 4:50 pm
sstomp (6/20/2014)
We are getting this error message when attempting to connect a linked server to an ODBC data source logged in with SQL authentication:OLE DB provider "SQLNCLI10" for linked server "AT-LINKED" returned message "Deferred prepare could not be completed.".
Msg 7303, Level 16, State 1, Procedure JCJob, Line 3
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CE_LINKED".
Msg 7399, Level 16, State 1, Procedure JCJob, Line 3
The OLE DB provider "MSDASQL" for linked server "CE_LINKED" reported an error. Authentication failed.
OLE DB provider "MSDASQL" for linked server "CE_LINKED" returned message "Error 20000002: An error has occured while opening a file, Error 00000005: Access is denied. , file "E:\GDr\Con\Da\X\xxxxxx.dat"".
OLE DB provider "MSDASQL" for linked server "CE_LINKED" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
When we login to the same linked server with Windows authentication, there is no error and the connection works perfect.
Any advice on how to resolve ?
Kindly put the hands on the keyboard where I can see them, then slowly produce your sql version number, odbc configuration and any other details that might or might not be used against the problem.
😎
June 21, 2014 at 5:19 pm
An error has occured while opening a file, Error 00000005: Access is denied. , file "E:\GDr\Con\Da\X\xxxxxx.dat"".
What are you linking using SQL server login?
Igor Micev,My blog: www.igormicev.com
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply