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

  1. Expand Documents
  2. Expand HOL
  3. Expand vIDM On Prem
  4. Right click on CreateVidmDB.txt
  5. Click Edit with Notepad++

Select All

In Notepad++,

  1. From the toolbar, click on Edit
  2. Click on Select All

Copy

  1. From the toolbar, click on Edit
  2. 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.

  1. Search for SQL Server Management Studio
  2. Click on SQL Server 2014 Management Studio

Connect to SQL Database Engine

In Microsoft SQL Server 2014,

  1. Select Database Engine as the Server type
  2. Select sql-01.corp.local to connect to the SQL server install in your lab.
  3. Select Windows Authentication as the Authentication.
    You should be authenticating with your current logged in user CORP\Administrator
  4. Click Connect

Create a New Query

  1. Click on Databases
  2. Click on New Query

Paste the Contents of the CreateDB script

  1. Ensure that the database selected is master
  2. Right click in the area for New Query
  3. Click on Paste

Execute the Create DB Script

Once the script is pasted, click on Execute to run the script

Refresh the DB List

  1. Right click on SQL-01.corp.local
  2. Click on Refresh

Validate that vidmdb is created

  1. Expand Databases
  2. Validate that you are now seeing vidmdb in the list of databases.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.