If you think a professional is expensive, wait 'til you see what an amateur can cost you!
Posts tagged SSO
VMware vSphere 5.1 Single Sign On (SSO) and SQL 2012
2When 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.
Recent Comments