Wednesday, March 28, 2012

link sql servers using enterprise manage

Hi
Can anyone explain me the options for linked servers in the enterprise
manager.
I've tried to link another sql server but i'm gettng errors.> 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\Micros
oft%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|||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 admi
n
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:

> Check the "Configuring Linked Servers" topic in Books OnLine
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\
ad
> minsql.chm::/ad_1_server_4uuq.htm).
>
> Any specific errors?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>

No comments:

Post a Comment