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.

Leave a Reply

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

Show Buttons
Hide Buttons