SQL 2008 R2 Cluster – SP1 update failure

August 28, 2012

I came across this strange error when applying SP1 to a SQL 2008 R2 Cluster. The Service Pack 1 install failed with the following error:

Error 1334. The file ‘ENG_SEI_RsFxDrv_0151_inf_64’ cannot be installed because the file cannot be found in cabinet file ‘Redist.cab’. This could indicate a network error, an error reading from installation media, or a problem with this package.

The failure occurred on the following screen:

Microsoft SQL Server 2008 R2 Service Pack 1

The second part of the error message indicated ‘network error, error reading from install media’ – so I initially tried to copy the setup files locally (this is something usually do, but in this case I did run the setup from our software share) – but it failed again with the same error.

After a lot of digging around and ‘googling’ on various keywords in the error log, I discovered that the ‘RsFxDrv’ part of the error related to the ‘FileStream’ SQL Server feature. Note: I had not enabled Filestream during the original SQL Server setup.

Resolution

I enabled ‘Filestream’ as per http://msdn.microsoft.com/en-us/library/cc645923.aspx and then re-applied Service Pack 1 and the update completed successfully!

I’ve not had a chance to test this any further and I don’t believe that this approach is required for everyone out there (i.e. having to enable filestream on a SQL Cluster before applying SP1) – but hopefully if anyone does come across this strange error, it will help them get past it.

The Filestream feature can always be disabled after patching, but it’s a quick, easy way to get past this error and move on to bigger and better things like supporting, monitoring and working with your new cluster!

Thanks for reading.

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

%d bloggers like this: