How to link 2 sql server step by step?

Hi experts

i have 2 sql server
one is on SQL SERVER 2000 and the other one is on SQL SERVER 2005

i have to link both server to make some query from sql 2005 to sql2000

can you show me step by step how to link both server and make the query?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
Hi Dnx_7,
Go to EM.

- Choose Database
- Select Security
- Then choose Linked Server
- Right Click on Link Server
- Enter Server Name, and User name/password.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dnx_7Author Commented:
in sql studio (sql 2005 enterprise management)

i right click on link server
> new linked server
here there are some parameter to set

linked server?
server type ?

sql server or Other data source.

if i choose sql server, there is nothing to set and if i choose other data source i can set some parameter like provider, product name, data source, provider string and catalog.

can you tell me what i have to do?

Dnx_7Author Commented:
oh that's ok, i found the solution


i accept your solution because it helps me to get the solution
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Aneesh RetnakaranDatabase AdministratorCommented:
> linked server?
Name to identify the server, you can give any valid name

> server type ?
SQL server

after this Click 'Security' from the left pane, there u can add the user
Aneesh RetnakaranDatabase AdministratorCommented:
Ok, u had done that, Now read this article also
once linked you can reference the tables on the other server

select * from <servername>.<dbname>.<dbowner>.<tablename>

all the regular commands are available.

Dnx_7Author Commented:
thanks to you all
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.