Home / server / Questions / 523383
Accepted
Mike Cole
Asked: 2013-07-16 05:45:48 +0800 CST

Configuring SQL Server 2012 instance to have multiple instance names

  • 772

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?

sql-server-2012

1 Answers

  1. Best Answer

    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.

    • 1