- 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.
- Kubernetes修煉手冊
- Mastering ElasticSearch
- Windows Server 2019 Cookbook
- Learning Android Intents
- 玩到極致 iPhone 4S完全攻略
- Linux集群和自動化運維
- Linux操作系統應用編程
- Windows Vista融會貫通
- Linux Shell編程從入門到精通（第2版）
- Java EE 8 Design Patterns and Best Practices
- Django Project Blueprints
- VMware Horizon Mirage Essentials
- 辦公自動化教程（Windows7+Office2010）
- Mastering Azure Serverless Computing
- Apache ShardingSphere權威指南