We help IT Professionals succeed at work.

How do I link 2 sql server databases?

ProfJames
ProfJames asked
on
Medium Priority
683 Views
Last Modified: 2012-06-27
Hi

I have two servers both windows 2003 and running sql server 2005. Each server has one database in it and I would like to know how I get a link table (or something similar) on server1 to a table on server2 so that I can run views on server1 which will pull data from server2?

I've seen some info about sp_addlinkedserver but I don't know if that's what I want to use and if it is, how do I use it?

Thanks for any help you can give me.
Heather
Comment
Watch Question

Commented:
You should set up linked servers for this.

Check this link for more info

http://msdn2.microsoft.com/en-us/library/ms190479.aspx
Commented:
The easiest way is to create the link in Enterprise Manager:

EM -> Security -> Linked Servers -> Right Click New Linked Server

Then just add the server name (ensure this server is visible through the network, e,g, telnet <target server> 1433). You will need a login to the target server.

Now you will be able to run sp's, pull data update the target server at you leisure.

Cheers
Si

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.