Part 2: Installing SQL for vRealize Automation (vRA) 7.5

This post will cover the SQL server installation for vRA. Please note for before starting vRA configuration and IaaS server we need SQL server.

If you already have a shared SQL server/Cluster. Please ignore this post and move to part 3.

For this setup i am installing SQL on the IaaS server, but in production deployments its recommended to install DB on separate server or use shared SQL Cluster resources. Only one DB will be created by vRA.

Please find the links for all the posts in this series below.

  1. Introduction and Design : Installing and Configuring vRealize Automation (vRA) 7.5
  2. Part 1: Deploying vRealize Automation (vRA) 7.5 Appliance
  3. Part 2: Installing SQL for vRealize Automation (vRA) 7.5
  4. Part 3: vRealize Automation (vRA) 7.5 Installation and IIS server Configuration
  5. Part 4: vRA 7.5 Initial Configuration of Default tenant and AD Directory Sync
  6. Part 5: vRA 7.5 Sub tenant Creation and Branding
  7. Part 6: vRA 7.5 Custom Groups, End points and Reservation Configuration
  8. Part 7: vRA 7.5 Infrastructure and XaaS Blue Prints Creation
  9. Part 8: vRA 7.5 Approvals, Catalog Management and Testing Blue Prints
  10. Part 9: vRA 7.5 fixing installation errors and configuration issues

Pre-requisites

  • SQL Media and a server to install SQL
  • Service account with static password if you want to run SQL Services with service account.
  • Service account for vRA IaaS with static password, this account should have access to SQL to automatically create VRA DB.

SQL server installation for VRA

Mount SQL media to server – Setup – Installation – new SQL server standalone installation.

Note:In your case you might need to deploy SQL in cluster so you have to follow cluster.

Accept – next

 

next


I dont have internet in this server to update checking is failing – ignore – next


Click on SQL server feature installation


Select all features you might require, basic one is Database engine services and tools – Next


Review and Next


Set everything to automatic as shown , if you are using SQL service account to start services click and select those accounts, i am using default.


select mixed mode – provide password – select add current user


Add current user – next


Review and Click Install


Now the installation is completed, it might take 30-40 mins to complete.

Connect to your SQL server using the SQL management studio and verify. Add sslab\vraadmin ( vra service account) to sql server under logins and give permissions to create DB, initially i recommend to give sysadmin, after config provide DB owner.

If you are not able to connect to SQL server from outside any server, Open SQL configuration manager and enabled the Named pipes in TCP-ip and start services.

Please find the links for all the posts in this series below. Click on the link below for the next post in this series.

  1. Introduction and Design : Installing and Configuring vRealize Automation (vRA) 7.5
  2. Part 1: Deploying vRealize Automation (vRA) 7.5 Appliance
  3. Part 2: Installing SQL for vRealize Automation (vRA) 7.5
  4. Part 3: vRealize Automation (vRA) 7.5 Installation and IIS server Configuration
  5. Part 4: vRA 7.5 Initial Configuration of Default tenant and AD Directory Sync
  6. Part 5: vRA 7.5 Sub tenant Creation and Branding
  7. Part 6: vRA 7.5 Custom Groups, End points and Reservation Configuration
  8. Part 7: vRA 7.5 Infrastructure and XaaS Blue Prints Creation
  9. Part 8: vRA 7.5 Approvals, Catalog Management and Testing Blue Prints
  10. Part 9: vRA 7.5 fixing installation errors and configuration issues

Hope this post is useful, please leave your comments below.

Siva Sankar

Siva Sankar works as Solution Architect in Abu Dhabi with primary focus on SDDC, Automation,Network Virtualization, Digital Workspace, VDI, HCI and Virtualization products from VMWare, Citrix and Microsoft.

4 thoughts on “Part 2: Installing SQL for vRealize Automation (vRA) 7.5

  • May 17, 2020 at 10:17 pm
    Permalink

    Hi,

    Excellent guide for vRA configuration and thanks for the step by step instruction for beginners like me.

    I need your guidance on the below part:

    Add sslab\vraadmin ( vra service account) to sql server under logins and give permissions to create DB, initially i recommend to give sysadmin, after config provide DB owner. – i need step by step instruction for doing that. As DB is totally new to me, I am unable to proceed on this.

    My lab setup is running in:

    Windows server 2019-Domain Controller
    Windows server 2019 – SQL server 2014 edition
    ESXi -7 – where I have installed vCenter server 7 ( created a data center by adding ESXi 6.7 host)
    Esxi – 6.7 – Configured vRA 7.5 appliance

    After installing vRA, in automatic installation wizard every thing went successful. But it failed in :

    The above exception is because I have not used service account vraadmin and used Administrator account

    .com\WEB

    Database connection failed. Verify that you are using the full instance name typed correctly, that the database user and password are correct, and that TCP/IP is enabled for the instance. Error details: Login failed for user ‘XXXX\Administrator’.

    .com\Manager Service:

    Database connection failed. Verify that you are using the full instance name typed correctly, that the database user and password are correct, and that TCP/IP is enabled for the instance. Error details: Login failed for user ‘XXXX\Administrator’.
    The Windows log on identity [XXX\Administrator] could not be verified as having the “Log on as a service” right (Windows Local Policy). This right is required for the domain user that you plan to use to start the Manager Service.

    Can you please help on that?

    Thanks in advance.

    Reply
  • May 25, 2020 at 2:18 pm
    Permalink

    Siva,

    Thanks for the prompt response and able to do SQL server configuration as per the guidelines.

    Now in the vRealize configuration wizard it went successful till the snapshot and went to proceeded next step for installation.

    It is failed in the below component and below is the error message.

    iaas.XXX.com\WEB Web Failed

    nModel Manager Data configuration failed.\r\n\r\n\r\nvCAC-Server-Custom-Web-ConfigTool Installation Failed, ExitCode:1\r\n\r\nError configuring vRealize Automation Server. For more information, refer to vCAC-Config.log after collecting the IaaS logs.\r\nExecution time:00:20.105\r\n”

    when I have searched for the error message, I found that issue is because of the certificates in IAAS server (i am using Windows 2019)

    I am not getting proper guide for installing certificates

    Can you please guide me in installing certificates in IAAS server?

    Thanks in advance

    Reply
    • May 28, 2020 at 12:04 pm
      Permalink

      Dear

      Create certificate on your CA , export as PFX and install the PFX on the IaaS server.

      It is always worthwhile to revert to snapshot and try installing again. it might work.

      Thanks

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Show Buttons
Hide Buttons