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:
Copy the
rsaIMSLiteMSSQLSetupUsers.sqlscript 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\mssqlOn the database server machine, start the Microsoft SQL Server Management Studio and make sure that you are connected to the correct database server instance.
Drag-and-drop the
rsaIMSLiteMSSQLSetupUsers.sqlfile to the SQL Server Management Studio.Enter new passwords for the
RSA_DBAandRSA_USERusers.
Here is how the script would look after the passwords have been supplied:
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.
