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

We are replacing an old SQL Server 2000 box with new hardware and SQL 2008. If we name the new server the same as the old will ODBC connections still work? What about replication and linked servers?

share|improve this question

If you give the new server the same name, configure logins and roles the same way and attach (or restore) the databases to it, yes, connections should work (possibly with some upgrade to the client SQL connectivity software, depending on the O.S. used).

Replication and linked servers will need to be reconfigured from scratch on the new server, though.

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.