- 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.
- 蘋果電腦玩全攻略 OS X 10.8 Mountain Lion
- 玩到極致 iPhone 4S完全攻略
- 混沌工程實戰：手把手教你實現系統穩定性
- 奔跑吧 Linux內核（入門篇）
- 蘋果OS X Mavericks 10.9應用大全
- Delphi Programming Projects
- NetDevOps入門與實踐
- bash shell腳本編程經典實例（第2版）
- Raspberry Pi入門指南
- Agile IT Security Implementation Methodology
- Linux操作系統案例教程（第2版）
- 再也不踩坑的kubernetes實戰指南
- 程序員必讀經典（算法基礎+計算機系統）
- SAP后勤模塊實施攻略：SAP在生產、采購、銷售、物流中的應用
- Microsoft DirectAccess Best Practices and Troubleshooting