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


