SlipStream sql server 2014(RTM + SP + Hotfix)

Slipstream is a new installation method in SQL Server where SQL Server RTM + Service Pack + Hotfixes can be packaged together. This feature has been introduced from SQL Server 2008 SP1.

Just sharing the Supported Command Prompt Installation Scenarios below :

  • Installing, upgrading, or removing an instance and shared components of SQL Server on a local computer by using syntax and parameters specified at the command prompt.
  • Installing, upgrading, or removing a failover cluster instance.
  • Upgrading from one SQL Server edition to another edition of SQL Server.
  • Installing an instance of SQL Server on a local computer by using syntax and parameters specified in a configuration file. You can use this method to copy an installation configuration to multiple computers, or to install multiple nodes of a failover cluster installation.

This Command Prompt Installation is very helpful on Windows Server Core Machines  where we have only Command prompt Available to see after logging to Server , as the Server Core installation eliminates  services and other features  which are not required for the support .

Below is how we should do to SLIP STREAM SQL 2014 and higher versions

  • Keep it ready with SQL Server 2014 media
  • Keep it ready with Needed SPs, CUs and Hotfixes that you want to Include
  • Keep all of the .exe files in one directory

There are two types of slipstream methods.
1)      Simple Slipstream

2)      Advanced Slipstream

Simple Slipstream (2014):
This is command based installation which requires bit knowledge on installation parameters. These are the parameters we need to know before going with this installation.

–      /Action =Install

      /UpdateEnabledTrue or 1    or    False or 0            

      /UpdateSource= MU   or    UNC path    or    .\Myupdates

Advanced Slipstream (2014)

As you guys helped by copying the SQL 2014 RTM Media and SP3 + KB on Server . I have created a New Folder called UPDATES inside SQL 2014 Media and copied both SP3 , KB [ here I think we need to follow Proper Naming Format for .exe files like SQLServer20XX-kbxxxxxx-Architecture.exe ( Hotfix ) and SQLServer20XXSPX-KBXXXXXXX-x64-ENU.exe ( Service Pack ) ]

After performing above we need to do one more Important step is to Update DefaultSetup.ini File ( which exists in SQL 2014 Installation Media  ) by providing the Location of Patches  ( here we need to give Updates Folder Location )

In below Screen Shot we are Specifying the location where SQL Server setup will obtain checking in Product Updates TAB in Installation

UpdateSource = ” path of patches ” — It can be a local path or UNC shared path or if the patch folder is in Media folder it self we can give it like .\FolderName

Now Once we Start Installation by initiating setup.exe and going through next steps we can see the difference at Product Update TAB like below

By seeing this above can say  that we have Embed all the 3 ( Media + SP + Hotfix ) to make SLIP STREAM Installation ..

Note : This SLIP STREAM Installation was introduced from SQL 2008 onwards but the process of doing Slip Stream in SQL 2008R2 is a bit more complicated compared with the latest releases

In-place Upgrade from SQL Server 2008R2 to SQL Server 2014

Currently I am running an older version of SQL Server 2008R2 and want to perform an in place upgrade to SQL Server 2014.

Upgrades from Earlier Versions to SQL Server 2014 :

SQL Server 2014 supports upgrade from the following versions of SQL Server:

  • SQL Server 2005 SP4 or later
  • SQL Server 2008 SP3 or later
  • SQL Server 2008 R2 SP2 or later
  • SQL Server 2012 SP1 or later

Now the first thing to do is to download SQL Server 2014 media directly from Microsoft. Once the downloading is finished, double click the file to begin the installation. 

After launching the SQL Server setup, the SQL Server Installation Center window will display. Clicking on Installation TAB on the left side will display the different installation options. For this tip, we will click on “Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012”. This will launch the Upgrade to SQL Server 2014 application.

The Upgrade to SQL Server 2014 application lists the steps it will follow on the left side of the window. Enter the product key and click “Next >”.

Review the license terms, click on “I accept the license terms”, and then click “Next >”.

The Global Rules TAB will check if there any Rules failed to stop this Installation or not

Here I have SLIP STREAMED SQL 2014 Media with SP3 and HotFix So, that we can eliminate Multiple Reboots of Server and also SAVING TIME. From below ScreenShot we can observe the difference of Include SQL Server Product Updates checkbox ENABLED  ( Service Pack 3 and HotFix which was added to Installation Media )

The upgrade application will download, extract and install files needed to carry out the installation process. Click on “Next >” to continue.

Select the SQL Server instance to modify. Click on “Next >” to continue.

The next step is the feature selection. In the example shown below, all of the features will be upgraded. Click on “Next >” to continue.

The Instance Configuration screen allows the installer to specify the instance ID. This screen will also display other installed instances. In this example, the MSSQLSERVER instance on SQL Server 2008R2 will be upgraded to SQL Server 2014.

The Server Configuration screen shows the services to be installed, the service account name and the Startup Type. If you are installing SQL Server 2014 on a device with limited resources then the Startup Type should be set to Automatic (Delayed Start) instead of Automatic. Click on “Next >”.

The Full-text Upgrade screen provides three Full-Text upgrade options (import, rebuild and reset).

The Feature Rules screen will execute a rule check to make sure the upgrade process should successfully.

The Ready to Upgrade screen displays all of the features and prerequisites to be installed or upgraded. At this point, the installer can still go back to make changes or quit the process. Click on “Upgrade” to begin the upgrade of the SQL Server 2014 components.

The upgrade progress bar tracks the status of the upgrade.

Upon completion of the installation, click on “Close” to exit the Upgrade to SQL Server 2014 application.

As you will be instructed that you will eventually need to restart your computer for the changes to take place

Verify that all Features show as Succeeded in the Status column, then click Close.

Finally, restart your computer. Once your computer is restarted, Connect to your Instance and see the Upgraded SQL Server 2014.