Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to replicate our live server set up local using a single SQL database.

In SQL 2005 I would added 2 linked servers both referencing itself with different names, each point to a different table.

How do I do this in SQL 2008. I've try the various providers and different parameters butto no avail.

The local server is using a trusted connection so I dont need any usernames/passwords

Im ideally need to set up the following linked references:

DBSVR1 - mydb_master DBSVR2 - mydb_import

Any light on the subject would help, I managed to do it in 2005 about 8 months ago but cant remember how, now Im in 2008!

share|improve this question

Well I managed to do it via script as that worked without issue rather than the GUI

EXEC sp_addlinkedserver @server='DBSVR2',



                                             @datasrc='.',--the data source

                                             @provstr='Integrated Security=SSPI';
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.