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.
Randy Belcher
AFG Industries, Inc.