Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked servers
Message
 
 
To
13/03/2003 08:43:54
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00765329
Message ID:
00765342
Views:
17
>Hi!
> I'm a novice working with SQL Server 2000. I have to make queries using two distinct servers (local server1 and remote server2. I added a linked server on server1 but I am having problem logging to the remote server (server2). Are there options that must be setup on the remote server in order to log on to it and then make queries? Thanks a lot.

Pascal,

Take a look at sp_addlinkedsrvlogin system stored procedure in BOL.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform