January 29, 2015 at 1:50 pm
I am trying to create a linked server from SQL 2012 to 2008 by using a domain account. This domain account exists on both SQL boxes. I am trying to use "impersonate" option with "Not be made" if a login not defined in the list above. But I keep getting "Access to the remote server is denied because no login-mappping exists, error 7416" error. I have double checked this domain user exists on both SQL boxes with sys_admin right to it. I also checked the destination server have "trust this computer for delegation to any service" checked. I can use "Be made using this security context" option to make it work. What am I missing?
January 29, 2015 at 3:34 pm
Do you have any other linked servers setup on this server?
Setup linked servers. Had to run the following command to enable data access between systems to get linked servers working properly between my 2008 and 2012 servers. Have you done this yet?
EXEC sp_serveroption 'name-of-your-sql-server-here', 'DATA ACCESS', TRUE
January 30, 2015 at 10:12 am
Tried it, but not working...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply