I have a Local SQL User account on SQL2005 that when it is used to access a
link server the error "Access to the remote server is denied because no
login-mapping exists" Appears.
If I grant a Server Role of SYSADMIN to this User the Link Server works
fine. I tried to run grant permissions on all the possible Link Server Stored
Procedures without assigning the SYSADMIN role but the SP_TESTLINKEDSERVER
will fail. The only time this User can run this is when it is Assigned
SYSADMIN role.
Can anyone me figure out why this local SQL user account can't call a
link server without SYSADMIN rights?