Linking SQL 7 servers

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eric,

I've been trying to link servers thru the Enterprise Manager (go to security, right click on linked servers, select "New Linked Server") but then it gives me an informational message "Not implemented". I hit OK and then it gives me the "Linked Server Properties - New linked server property sheet". I then proceed to type in the server name (of the server i'd like to link to and for which i have full access)in the Linked server field, click on the radio button "SQL server" for the server type, and finally on the security sheet, i map the account to "sa".

It then goes on and creates that item. But when i click on that (linked server) item, i don't see any tables. i've tried this again and again but unsuccessfully... what gives?

hope you can help me out. thanks in advance.

- efren -

-- Anonymous, March 29, 2000

Answers

Efren,

I would take SQL Server at its word that the feature is not implemented in SQL Enterprise Manager. You can use the Transact SQL stored procedure sp_addlinkedserver instead.

The Knowledge Base article at:

http://support.microsoft.com/support/kb/articles/Q197/3/90.ASP

offers a little elaboration.

Hope this helps,

Eric

-- Anonymous, March 29, 2000


Moderation questions? read the FAQ