Create vIDM SQL Database
In this section, we are going to create a SQL Database for vIDM. During the vIDM installation process, we will be referencing this database as the target DB.
Ensure that you are on the Main Console server
Before we proceed with this section, let us ensure that we are back to the Main Console. You should be seeing all the RDP shortcuts on the Desktop. If not, please go back and follow the steps to close the RDP session from vIDM-01 VM to return to the Main Console.
Open Windows Explorer
Click on the icon to launch Windows Explorer
Open Create vIDM DB Script
- Expand Documents
- Expand HOL
- Expand vIDM On Prem
- Right click on CreateVidmDB.txt
- Click Edit with Notepad++
Select All
In Notepad++,
- From the toolbar, click on Edit
- Click on Select All
Copy
- From the toolbar, click on Edit
- Click on Copy
Open Start Menu
Click on the icon to launch Start Menu
Open SQL Management Studio
Before install the VIDM service, we will need to create a database in SQL.
- Search for
SQL Server Management Studio
- Click on SQL Server 2014 Management Studio
Connect to SQL Database Engine
In Microsoft SQL Server 2014,
- Select Database Engine as the Server type
- Select sql-01.corp.local to connect to the SQL server install in your lab.
- Select Windows Authentication as the Authentication.
You should be authenticating with your current logged in user CORP\Administrator - Click Connect
Create a New Query
- Click on Databases
- Click on New Query
Paste the Contents of the CreateDB script
- Ensure that the database selected is master
- Right click in the area for New Query
- Click on Paste
Execute the Create DB Script
Once the script is pasted, click on Execute to run the script
Refresh the DB List
- Right click on SQL-01.corp.local
- Click on Refresh
Validate that vidmdb is created
- Expand Databases
- Validate that you are now seeing vidmdb in the list of databases.
0 Comments
Add your comment