Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Security settings
Message
From
24/09/2002 09:42:10
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Security
Title:
Security settings
Miscellaneous
Thread ID:
00703747
Message ID:
00703747
Views:
41
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.
Next
Reply
Map
View

Click here to load this message in the networking platform