Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Security settings
Message
De
24/09/2002 09:42:10
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Titre:
Security settings
Divers
Thread ID:
00703747
Message ID:
00703747
Vues:
42
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform