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?


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.

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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