Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.