I tried using openrowset. Do I need permissions for that too?
I executed the following query on the remote server with IP of my local server in place of xxx.xxx.x.xx :
SELECT a.*
FROM OPENROWSET('SQLOLEDB','Server=xxx.xxx.x.xx;Trusted_Connection=yes;',
'SELECT *
FROM DService.dbo.device') AS a;
I get the following error message:
Msg 7416, Level 16, State 2, Line 1
Access to the remote server is denied because no login-mapping exists.
Really... what is it I'm missing out on?
I'm going nuts here!