i’ve been reading over the docs for upgrading to vcenter 5.1 the only gotcha i’ve come across is the manual setting up of the SSO (single sign-on) database and users. you would only do this if you were using a database other than sql express (which i imagine everyone does, at least in production). anyways, the steps necessary to set up the DB are very well documented.

the scripts are on the vcenter install media:
d:\single sign on\dbscripts\ssoserver\schema\mssql

edit the “CHANGE ME” portions of the rsaIMSLiteMSSQLSetupTablespaces.sql script to the location of where the SSO databases should reside.
a typical location might be: c:\program files\microsoft sql server\mssql10.mssqlserver\mssql\data

run the script and RSA_DATA.mdf, RSA_INDEX.ndf, and translog.ldf will be created.

next edit the password portions of rsaIMSLiteMSSQLSetupUsers.sql and then run it.

SSO database work should be complete at this point.

i almost missed this fact because it’s not very clear in the docs, but is stated in many blogs. sql server authentication needs to be changed to mixed mode as RSA_DBA and RSA_USER are SQL users.

sources:
http://vmwaremine.com/2012/11/12/prepare-dbs-for-vsphere-5-1-installation-or-upgrade-part-1/
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2034918#db
http://thephuck.com/virtualization/how-to-create-a-database-for-vcentersinglesignon-using-sql-express-2008-r2-vmware-vcenter-sso-vsphere51/
http://virtualpotholes.wordpress.com/2012/10/26/installing-vcenter-single-sign-on-with-sql-server/

Comments are closed.