-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

VMware vSphere 5.1 Cookbook
By :

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.
The following steps will help you create a DB user using the SQL script rsaIMSLiteMSSQLSetupUsers.sql
:
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
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.
Drag-and-drop the rsaIMSLiteMSSQLSetupUsers.sql
file to the SQL Server Management Studio.
Enter new passwords for the RSA_DBA
and RSA_USER
users.
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.
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.
Change the font size
Change margin width
Change background colour