Upgrade from SQL 2005 to SQL 2012 fails with error “Service ‘SQLSERVERAGENT’ start request failed.”

I was working on a 2005 to 2012 upgrade issue and came across an interesting issue which I thought of sharing with you guys.  Whilst running an upgrade from 2005 SP4 to 2012 RTM (and/or slipstreamed copy) it failed half way through, giving the error:   “There was an error attempting to remove the configuration…


SQL 2008 R2 CTP3 Upgrade directly to RTM.

“We’re getting questions on whether folks can upgrade directly from CTP3 to RTM.   The recommended and supported approach is to uninstall CTP3 and install the final release version when it is available.  We apologise for any conflicting information you might have heard earlier”   Regards, CSS SQL Server

How to reapply SQL 2000 SP4 to update all the 13 scripts

Due to any issue, you may want to rerun SQL 2000 SP4 upgrade. SQL 2000 Service Packs are cumulative. But when you re-run SP4 it only updates 7 Scripts those are new with SP4. This could be useful when SQL Server is already on SP3 and due to some reason the SP3 installation had not…


Error 11032 Unable to install Windows Installer MSP while installing security patch KB 948109 on SQL 2005 instance

While installing security patch KB 948109 on SQL Server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location,C:\Progarm Files\Microsoft Sql Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txtOne of the cause of the failure can be Error 11032…


How to convert a standalone Instance of SQL Server into an Clustered Instance

For SQL Server 2000:   Case 1: If the default instance of  sql server is to be upgraded to default clustered instance of sql server 2000 Note: 1)       Only Default instance can be upgraded by this method 2)        This Functionality is not vailable in sql server 2005 so if you want to convert a standalone…