- VMware vSphere 5.1 Cookbook
- Abhilash GB
- 220字
- 2021-08-13 16:56:23
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\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.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.
- Implementing Cisco UCS Solutions
- 構(gòu)建高可用Linux服務(wù)器（第4版）
- 發(fā)布！設(shè)計(jì)與部署穩(wěn)定的分布式系統(tǒng)（第2版）
- Linux Shell編程從入門到精通（第2版）
- Kubernetes從入門到實(shí)踐
- Linux系統(tǒng)安全基礎(chǔ)：二進(jìn)制代碼安全性分析基礎(chǔ)與實(shí)踐
- Linux服務(wù)器配置與管理
- Python UNIX和Linux系統(tǒng)管理指南
- Windows Vista終極技巧金典
- Learning BeagleBone
- 鴻蒙入門：HarmonyOS應(yīng)用開(kāi)發(fā)
- 15分鐘！畫出我的漫畫角色：賣萌篇
- C#實(shí)用教程（第2版）
- Mastering Spring Cloud
- Windows PE權(quán)威指南