Creating DB users for the SSO database

During the installation of the Single Sign On component, once the table space has been created, the installer would need a database username and password to generate a JDBC connection URL.

This user has to be manually created using the SQL script, rsaIMSLiteMSSQLSetupUsers.sql, available on the vCenter's installation DVD.

How to do it...

The following steps will help you create a DB user using the SQL script rsaIMSLiteMSSQLSetupUsers.sql:

1. Copy the rsaIMSLiteMSSQLSetupUsers.sql script from the vCenter's installation DVD to the database server. The location of the file is as follows:

   CD/DVD ROM :\Single Sign On\DBScripts\SSOServer\schema\mssql

2. On the database server machine, start the Microsoft SQL Server Management Studio and make sure that you are connected to the correct database server instance.

3. Drag-and-drop the rsaIMSLiteMSSQLSetupUsers.sql file to the SQL Server Management Studio.

4. Enter new passwords for the RSA_DBA and RSA_USER users.

   

   Here is how the script would look after the passwords have been supplied:

   

5. Click on Execute to run the script on the database server instance.

How it works...

On a successful execution of the query, it creates two security login accounts, RSA_DBA and RSA_USER. It also creates two security users, dbo and RSA_USER, for the RSA database. The dbo user is mapped to the RSA_DBA login and RSA_USER will be mapped to the RSA_USER login.