When installing or upgrading to VMware vCenter 5.1 you need to run a script on your existing database if you don’t go for the bundles Express Edition of Microsoft SQL Server 2008R2 Express. In my case I’ve used a dedicated Microsoft SQL 2012 Standard Edition server.

VMware wants you to run an SQL query located on E:\Single Sign On\DBScripts\SSOServer\schema\mssql called rsaIMSLiteMSSQLSetupTablespaces. Unfortunately this script used SQL syntax that isn’t supported by SQL server 2012. And with not supported I mean the Stored Procedures in the end of the script. Replace these lines in the bottom of the script with the ones below

EXEC SP_DBOPTION 'RSA', 'trunc. log on chkpt.', true
EXEC SP_DBOPTION 'RSA', 'trunc. log on chkpt.', true
ALTER DATABASE RSA SET AUTO_SHRINK ON
ALTER DATABASE RSA SET RECOVERY BULK_LOGGED

There you go. The query should run without errors on SQL Server 2012.