Hi all,
- I've created a linked server on SQL machine 1. Connection works fine, querying works fine.
- I've set up the proper credential mapping (windows authentication) for the appropriate users.
- When trying to use the linked server from different machines, the linked server connection only works
when the user is logged in on the original machine. If not, I get the standard error "SQL Server Cannot initialize the data source object of OLE DB provider MSDASQL for linked server".
-> The users are admin on both machines we're trying to connect from, as well as the machine where the linked server is defined.
-> They have the permission "Impersonate a client after authentication" as well as "Create global objects"
-> Running SSMS as admin does not work (and even then, we need to be able to run the query from a frontend client, without SSMS).
What am I missing? Why does this only work when the user is logged in? When we log out again, it stops working and is consistent across different users and machines.
Thanks,
Louis
