January 10, 2008 at 1:58 am
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
January 10, 2008 at 11:17 am
You need to create an login account in Server A and the same login in Server B. When you create the linked server between A and B, you use that login. Actually I would use window authentication and you don't have to worry about creating login account.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply