Install SQL Patches with SQL Media Installation (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.

I Just wanted to share Supporting Command Prompt Installation Scenarios please find below :

  • We can perform Installing, upgrading, or removing an instance and shared components of SQL Server on a local computer by using parameters and syntax specified at the command prompt.
  • We can also perform Installing, upgrading, or removing a FCI failover cluster instance.
  • We can perform SQL Server edition Upgrade from one edition to another edition of SQL Server.
  • Installing SQL Server instance on a local computer by using syntax and parameters mentioned in a configuration file. we can use this method to copy an installation configuration file to multiple computers for 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. Below are the parameters we have to know before starting 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

I had a change scheduled to perform In-place upgrade from SQL Server 2008R2 to SQL Server 2014.

SQL Server 2014 upgrade supports from 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

I have downloaded SQL Server 2014 media directly from Microsoft site. Once the downloading is finished, double click the file to begin the installation. 

After double clicking on SQL Server setup, the SQL Server Installation Center window will open. On the left side click Installation TAB it will show different installation options. For this change, we will click on “Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012”. This will itself launch the Upgrade wizard to SQL Server 2014 .

The Upgrade to SQL Server 2014 gives the steps it will follow on the left side of the wizard. Provide 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 and let us know if there are any Rules failed to stop this Installation

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 )

In Install Setup Files wizard the upgrade application will download, extract and install files which are 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. Here I have selected all of the features to be upgraded. Click on “Next >” to continue.

The Instance Configuration screen allows the installer to provide the instance ID and here we can also see other installed instances on the server. Here mine is a default instance MSSQLSERVER on SQL Server 2008R2 which will be upgraded to SQL Server 2014.

The Server Configuration screen lists the services which are getting installed, we can provide or change the service account name and the Startup Type. Click on “Next >”.

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

The Ready to Upgrade screen shows all of the features, prerequisites to be installed or upgraded. At this point, we can still go back to make modifications or quit the process. Once all are set then click on “Upgrade” to begin the upgrade of the SQL Server 2014 components.

The upgrade progress bar shows the status of upgrade.

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

We have to restart your computer for the changes to take place

Verify all Features which are showing as Succeeded in the Status column, then click Close.

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