Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 just installed SQL Server 2012 Standard Edition and set up a new default instance. Is there a way to "forward" connections from the old .\sqlexpress to the new default instance? Or do I need to hunt down and change all connection strings?

share|improve this question
up vote 1 down vote accepted

You'll have to update the connection strings if you've specified instance names in it and the instance name is changing. In the future, you should use SQL Server Aliases for production applications.

share|improve this answer
Thanks for the info! I didn't ever plan on the instance changing TBH. Guess I won't make that mistake again. – Mike Cole Jul 15 '13 at 13:53
Eventually, it will always change if your application has enough longevity to make it to where your hardware or OS needs to be upgraded. Aliases help ease that. – MDMarra Jul 15 '13 at 13:58

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.