Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

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?

regards
0
Dnx_7
Asked:
Dnx_7
  • 3
  • 3
1 Solution
 
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.

Aneesh
0
 
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?

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

regards

i accept your solution because it helps me to get the solution
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Aneesh RetnakaranDatabase AdministratorCommented:
Dnx_7,
> 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
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Ok, u had done that, Now read this article also

http://www.sql-server-performance.com/linked_server.asp
0
 
pjdeeCommented:
once linked you can reference the tables on the other server


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

all the regular commands are available.

0
 
Dnx_7Author Commented:
thanks to you all
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now