How to – create a database for vCenter Single Sign On 5.1

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\SQL).

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 rsaIMSLiteMSSQLSetupTablespaces.sql in the query box. This script will create a database called “RSA” and set some performance settings on the database (eg. autoshrink = on, recovery to simple)

Before you run the script, please customize the file paths named “CHANGE ME”.

You must replace three paths:

FILENAME=’C:\CHANGE ME\RSA_DATA.mdf’

Decide on a folder to hold the database files (10 GB of space required)

FILENAME=’C:\CHANGE ME\RSA_INDEX.ndf’

Decide on a folder to hold the index files

FILENAME=’C:\CHANGE ME\translog.ldf’

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.sql – but you do not need to run them.

You can now continue the installation using the vCenter Single Sign On Install wizzard…