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.

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
add comment

1 Answer

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
add comment

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.