An error occurred while executing a custom action:ExecuteSqlScripts – Several possibilities and solution installing System Center Service Manager 2012

Hi, when installing SCSM, System Center Service Manager 2012, you can get the following error at Create Database level :

“An error occurred while executing a custom action:ExecuteSqlScripts”

There are several possibilities to solve this issue which mean that something deny the database creation:

1st solution : Sql server not allows update

the database is not allowed to be upgrated so you can make a sp_configure ‘allow updates’ to check if sql server allow update (you will normally get a 0 value), if not configure it as below:

sp_configure ‘allow updates’,0 reconfigure with override

http://technet.microsoft.com/en-us/library/hh495585.aspx

2nd solution : Sql server targeted is on 2012 version

For me, the mistake was coming from the targeted version of sql server. I was used a 2012 sql server express, and after using a 2008r2 sql server on the wizard for SCSM 2012, all works fine at Create database level as you can see ;-):

Enjoys!