Create VMware Identity Manager SQL Database
In this exercise, we are going to create a SQL Database for VMware Identity Manager. During the VMware Identity Manager installation process, we will be referencing this database as the target database.
1. Copy the CreateVidmDb Script
- Click the File Explorer icon from the taskbar
- Click Documents
- Click HOL
- Click VMware Identity Manager
- Right-Click CreateVidmDb.txt
- Click Edit with Notepad++
2. Run the CreateVidmDb Script
From the Desktop, double-click SQL Server 2014 Management Studio
2.1. Connect to the SQL Database Engine
- Enter
sql-01a.corp.local
for the Server name. - Select Windows Authentication.
- Click Connect.
2.2. Create a New Query
- Click Databases.
- Click New Query.
2.3. Paste the Script Contents
- Ensure that the database selected is master.
- Right click in the area for New Query.
- Click Paste.
2.4. Execute the Create DB Script
Once the script is pasted, click on Execute to run the script.
These commands are accomplishing the following tasks:
- Creating the vidmdb database.
- Setting the necessary collation and configurations for the vidmdb database.
- Creating a user (
vidmuser
) with a password (VMware1!
). - Assigning the vidmuser the appropriate roles for the vidmdb database.
2.5. Refresh the Database List
- Right-click the sql-01a.corp.local server.
- Click Refresh.
2.6. Validate that the vidmdb Database Was Created
- Expand Databases.
- Confirm the vidmdb Database exists.
0 Comments
Add your comment