Slipstreaming SQL Install


Recently I had to Install SQL Server 2008 Standard on a cluster and our setup was giving error like  ‘Value cannot be null;Parameter=Connection’

This issue was fixed when I tried Slipstreaming. What is slipstreaming? This is a combination of all the patches to the initial install (RTM). When you copy newer files over older files a slipstream is formed.

Below are the steps, which I followed to fix the issue:

Steps :

1 . Copy original SQL Server 2008 source setup to c:\SQLServer2008_FullSP1

2. Extract service pack to SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU

3. Copy Setup.exe and Setup.rll from the PCU extracted location to original source setup location

4. Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in c:\SQLServer2008_FullSP1\PCU\<architecture> to C:\SQLServer2008_FullSP1 \<architecture> to update the original files.

5. Modify the defaultsetup.ini by adding PCUSOURCE=”{Full path}\PCU”,ie PCUSOURCE=”C:\SQLServer2008_FullSP1 \PCU”

6. Ran the setup

Cluster was build and there was no more errors.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s