You'll have to create a Linked Server on the other server back to your local server. Remember that the query is being run on the other server even though you're sitting somewhere else.
-Mike
>hello everyone, i am trying to access my local server on my laptop through a sql query on another server. the query looks like the following:
>
>SELECT Inventory.Descr, Inventory.InvtID, Inventory.User6
>FROM Inventory
> INNER JOIN OPENROWSET('SQLOLEDB',
> '(local)';'x';'123',
> 'select * from medex.dbo.inventory') LocalInv ON
> Inventory.InvtID = LocalInv.solomonid
>
>i receive the error : communication link failure if i query through SQL server
>
>and I get login failed for user 'x' in the Query analyzer.
>
>could my security settings be setup wrong for my local server? it only checks windows authentication. I really don't know too much about changing these settings and adding the proper security settings.
>can anyone help? thanks.