One of your current third-party applications has been certified to run on SQL Server 2008 R2 but not 2005. Your company has just bought a new application that requires SQL Server 2005 to run. How can you run both of these application with minimal over and expense?

One of your current third-party applications has been certified to run on SQL Server 2008 R2 but not 2005. Your company has just bought a new application that requires SQL Server 2005 to run. How can you run both of these application with minimal over and expense?

One of your current third-party applications has been certified to run on SQL Server 2008 R2 but not 2005. Your company has just bought a new application that requires SQL Server 2005 to run. How can you run both of these application with minimal over and expense?


Answer – Install SQL Server 2005 as named instance, and configure your new application to use the new instance.

(The option with the least administrative overhead and lowest cost is to install 2005 as a named instance. But you can’t install it as the default instance without first uninstalling SQL Server 2008 R2.)