Quick one today:
When we install Sql Server software on a Windows machine, sometimes, we need to install Service Packs (SP); Either SP1 or SP2 or SP3, etc. As service packs are cumulative, it helps to keep it down to a two step process. In some scenarios, this two step process is not posible due to version conflicts that do not allow RTM Sql Server versions on later versions of OS.
SlipStream allows us to combine these two steps into one. Combine RTM version with ServicePacks (SP) and install them together.
- Reduce or remove need for multiple restarts
- Reduce install duration times
- Avoid version conflicts mentioned above (RTM Sql Server versions may not work on later versions of OS)
- Install any prerequisites like .Net 3.5
- Install Windows Installer 4.5
- Download and extract SP file to a local drive a.k.a. C:\Temp\SP1\
- Run the Service Pack (SP) first to install Setup & Support files. This prevents any surprises when actual install is performed.
- Open Command prompt as Administrator
- Go to the location where install DVD is located.
- Use this command to run install in SlipStream mode.
- Setup.exe /PCUSource=C:\Temp\SP1
- After a second or two, the Sql Installer Wizard opens
- Walk through the normal install steps.
- When you get to the “Ready to Install” screen, it indicates that SlipStream is engaged during this install (see in the image below).
- Perform restart if you need to.
Please note that this is just one of the techniques. On Microsoft Support, they have other options detailed with troubleshooting techniques.