When you upgrade your vSphere Environment to 5.1 you will have to install vCenter Single Sign On first.
During installation, you can decide if you want to use a local installation of Microsoft SQL Server 2008 R2 Express or if you want to use a supported existing database.
If you decide not to use the bundled database you will have to create a Single Sign On database performing the following steps:
• Check the information about vCenter Server 5.1 supported database versions!
• Now create a new database using sql scripts delivered with the installation media (installation_media\single sign on\DBScripts\SSOServer\Schema\
To do so, open your SQL Server Management Studio and connect to your database server using an account with admin privileges.
Select “New Query” and copy the .sql script named rsaIMSLiteMSSQLSetupTablespace
Before you run the script, please customize the file paths named “CHANGE ME”.
You must replace three paths:
Decide on a folder to hold the database files (10 GB of space required)
Decide on a folder to hold the index files
Decide on a folder to hold the log files
If you want, you can change the database name, too. Default name of the Database will be “RSA”.
When you have customized everything you can run the script – and you should get a message saying “Query executed successfully”.
In the next step you will have to create the users, using the script rsaIMSLiteMSSQLSetupUsers.sql.
Copy the script in the query box and change the password for the user RSA_DBA and RSA_USER:
Run the script and hopefully you will see the success message again.
Please note: There are some more scripts like rsaIMSLiteMSSQLCreateSchema.
You can now continue the installation using the vCenter Single Sign On Install wizzard…