Re: link sql servers using enterprise manage
From: Mohd Sufian (sufian_at_aeroflex.co.th)
Date: 03/30/05
- Next message: Dan Guzman: "Re: Why Windows Authentication?"
- Previous message: Sue Hoegemeier: "Re: Sysadmin role"
- In reply to: Dejan Sarka: "Re: link sql servers using enterprise manage"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 29 Mar 2005 23:35:04 -0800
do u know the ip address of your second server if yes then enter the name or
the ipaddress then give the username as u use for your local server and admin
as username for remote server and give the password as your local server
password
and in the server option use select the above five options
and set ok
it will work for u but keep one thing in mind that u can not see the tables
or views u can only execute the hetrogenious queries.
from
sufian
"Dejan Sarka" wrote:
> > Can anyone explain me the options for linked servers in the enterprise
> > manager.
>
> Check the "Configuring Linked Servers" topic in Books OnLine
> (mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ad
> minsql.chm::/ad_1_server_4uuq.htm).
>
> > I've tried to link another sql server but i'm gettng errors.
>
> Any specific errors?
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
>
>
- Next message: Dan Guzman: "Re: Why Windows Authentication?"
- Previous message: Sue Hoegemeier: "Re: Sysadmin role"
- In reply to: Dejan Sarka: "Re: link sql servers using enterprise manage"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
