Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed

[In addition to blogging, I am also now using Twitter for quick updates and to share links. Follow me at: twitter.com/pabloperalta] 

Hi,

It recently happened to me that when I wanted to apply latest Rollup on an existent Microsoft Dynamics CRM 4 installation I got the following error:

Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed

After some research I really couldn't find much useful information, and hence, started to try some things. I found that despite the user I was logged on were administrator on CRM server machine, it wasn't Administrator on CRM Deployment Manager. Also found that it wasn't dbowner on CRM databases and didn't have 'CRMReaderRole' on CRM databases neither.

Nevertheless, after having been granted all of that permissions I still had the same error.

The solution.

Finally, the solution was granting the logged on user sysadmin permissions on SQL Server.

After some readings at 'Installation & Deployment in CRM Student_Manual' (Microsoft Official Curruculum) it made some sense as it explicitly says that:

The user installing Microsoft Dynamics CRM must be granted the following privileges at a minimum:

• Ability to create objects within the Active Directory organizational unit that is the target parent organizational unit for installing Microsoft CRM.
• SQL Administrator privilege.
• IIS Server local administrator privilege.
• Local Administrator on the computer where Microsoft Dynamics CRM Server is to be installed.

 

Anyway, it's not so clear that SQL administration privilege is also needed when you want to install a Rollup for instance, but, it seems it is.

So, if you face same error, try granting the user sysadmin privilege on SQL Server.

Hope this helps to save somebodyelse some time,

PP