Step by Step Instructions on how to put the Installer Cache back together for SQL following “Unable to install Windows Installer MSP file” errors 1612 1635 1642 1646 Technorati Tags: SQL , Service Pack , Cu , 1612 , 1646 , 1635 Background: To...

It has been a while since I posted, but here is a very quick tip, not 100% SQL related but it certainly applies to SQL Server installations after SQL2005. You might notice that in the C:\Windows\Installer directory you have got lots and lots of files...

A recent issue I saw was that the SQl service would not come on line on an x64 cluster. my prefered method of looking at cluster failovers / failure to start is to first look at the errorlog. This is to a large part to get aquainted with the server and...

The server in question was once a SQL2000 cluster and had been upgraded by some means to SQL2005, following this when opening Cluster Administrator the following error is displayed immediately. An error occurred attempting to read properties for the ...

To follow up on my last post.....a similar issue occurs when performing an edition upgrade to Notification Services, same error codes are returned but this time against the NS component. Checking the registry / file versions also reflect the same situation...

When performing an edition upgrade on SSIS Service Pack 2 + Cumulative Update its best to uninstall the CU *before* you run the edition upgrade, this will avoid some issues that can occur when following the upgrade you come to re-apply Service Pack 2...

This is quite a strange situation I've seen when applying SP2 or hotfix to a SQL2005 cluster, reviewing the Summary.txt file the failure is something like this... ---------------------------------------------------------------------------------- Product...

Following some encouragement from colleagues I've finally started this blog. I am not going to say that the focus if the blog is going to be in any one area of SQL, but a lot of my time is spent focused on clustering / high availability so am expecting...

I thought I'd share a very strange setup issue that we've seen a number of times both with Service Pack 4 and Hotfix installation. When applying SP4 for SQL2000 the setup fails with the usually cryptic message about setup failing on a remote node....