none
Configuration File for New Install vs Adding an Instance

    Question

  • I have a configuration file that works when installing SQL Express with a named instance on a computer that does not currently have SQL installed. Can I use this same configuration file to add a named instance to an existing SQL installation?
    Thursday, December 29, 2016 3:45 PM

Answers

  • Yes, the same configuration file should work fine. The only default instance is the MSSQLSERVER instance name. Even though SQL Express defaults to an instance name of "SQLEXPRESS", it is still a named instance. Thus you can use the same configuration file with any other named instance as well (assuming the instance name is not already in use).

    Thanks,
    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by JT65 Thursday, December 29, 2016 6:30 PM
    Thursday, December 29, 2016 6:21 PM
    Moderator

All replies

  • Yes, the same configuration file should work fine. The only default instance is the MSSQLSERVER instance name. Even though SQL Express defaults to an instance name of "SQLEXPRESS", it is still a named instance. Thus you can use the same configuration file with any other named instance as well (assuming the instance name is not already in use).

    Thanks,
    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by JT65 Thursday, December 29, 2016 6:30 PM
    Thursday, December 29, 2016 6:21 PM
    Moderator
  • My life just got easier, but as soon as I asked this question, it prompted another.

    I've created a script that looks to see if SQL is already installed.  If so, what version is it?  Also, does a specific instance already exist.

    For systems that do not have SQL installed, there's no problem.  I'll simply install SQL 2008 R2 and create my named instance.  Off the top of my head, I don't know what service pack might be included.  For now, let's assume it SP1.

    What I'm suddenly worried about is finding a system that does not have the named instance, but has SQL 2008 R2 with Service Pack 2.  Is it going to be a problem when I launch my SP1 installation and install?

    Thursday, December 29, 2016 6:30 PM
  • Nope, this won't cause a problem either. Let's stick with your scenario.

    1. The machine already has SQL Server 2008 R2 with SP2 (instance name "SP2Installed").

    2. You detect "SP2Installed" instance is already installed and can still install your new instance (instance name "AnotherInstance").

    Assuming that you installed the RTM version in step 2, you would now have two instances:

    SP2Installed - Running 2008 R2 with SP2
    AnotherInstance - Running 2008 R2 RTM

    When you launch 2008 R2 SP1 to patch "AnotherInstance", discovery will detect the current versions and only allow you to apply the SP to the RTM instance. If you tried from command line to patch "SP2Installed", you'd get an error message telling you that it is already at a higher version.

    Does that make sense?

    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, December 29, 2016 6:38 PM
    Moderator
  • Also, not sure if this helps, but you can slipstream the install to include the service pack to do it all in one install.

    Here's a blog entry explaining how to do it with SP1, but the same process applies for all SPs.

    https://blogs.msdn.microsoft.com/petersad/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1/

    Thanks,
    Sam Lester (MSFT)


    https://blogs.msdn.microsoft.com/samlester/

    Twitter - @SQLSamLester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, December 29, 2016 6:39 PM
    Moderator