Hi,
I have a situation where we are using a linked server on server A going to server B, from a database on server A we are executing a stored proc which selects data via the Linked server in a DB on server B.
The linked server is defined with a security setting as:
"Be made using this security contrext" and using sql login security against server B. when using the dedicated OLEDB driver of the linked sever we get this error message:
Server: Msg 7416, Level 16, State 2, Line 1
Access to the remote server is denied because no login-mapping exists.
But the dropping the Linked server and re creating it using the OLEDB provider for ODBC, everything works.
So clearly not an issue with security on the remote server, but can anyone explain me why it would start work on the ODBC provider?
The ODBC one is clearly slower than OLEDB, so I would like to get the OLEDB one working.
Thanks in advance.
//SUN