Erland,
you will know :)
I'm using this tracking version to call some procedure on my remote server:
EXEC('[dbo].[my_procedure] ?', @change_tracking_version) AT [myRemoteServer]
Inside this procedure on remote server I'm reading back one table which is on local server:
INSERT INTO #tmp_category ( code )
SELECT code FROM OPENROWSET('SQLNCLI', 'Server=myServer;Trusted_Connection=yes;', 'set fmtonly off SELECT * FROM myDb.dbo.item_category WHERE transfer=0')
But I get an error:
"Access to the remote server is denied because no login-mapping exists."
How can I solve this issue with retaining trusted connection - since I don't won't to write user name and password into the code.
No comments:
Post a Comment