SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3.  The problem can happen for any SQL Server 2000, SQL…

1

Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

UPDATE TO THIS POST: We now have a fix for this problem as documented at 968829  FIX: Error message when you try to upgrade aninstance of SQL Server 2005 to SQL Server 2008: “Wait on the DatabaseEngine recovery handle failed. Check the SQL Server error log for potentialcauses” http://support.microsoft.com/default.aspx?scid=kb;EN-US;968829 However, because this is setup, you…

20