Install vRealize Automation IaaS SQL 2014 Installation – vRealize Automation Series Part 5


Jonathan Frappier Virtxpert

Almost time to install the IaaS components, but we still need a SQL server so lets get this party started, if you are installing SQL2012 you can check out my older post, in this post I will be installing 2014 with a bit less detail on selection choices.

  • Navigate to your download location of SQL and launch the installer
  • Click OK to allow the installer to extract the files to the requested location, the SQL Server Installation Center will launch
  • Click on New SQL Server stand-alone installation
  • Accept the license terms and click Next
  • I am going to skip the updates here for the sake of time, so leave the update box unchecked and click Next
  • On the Feature Selection screen I am only keeping Database Engine and sub components and Management Tools – Basic and Complete in the default directory
  • On the Instance configuration select Default and click next
  • On the Server Configuration page change SQL Server Browser to Automatic and click Next
  • On the Database Engine Configuration page change to Mixed Mode and set the SA password
  • On the Specify SQL Server administrators section add svc_vra_iaas (we can remove this user as a SQL admin after the installation of the IaaS components), click Next to proceed with the installation
  • Once finished, click the Close button and close the Installation Center screen

Before we move on to installing the IaaS components, lets log into SQL and make sure everything is as we want

  • Open the Start menu and type Management Studio
  • Log in with with Windows Authentication
  • Expand Security >> Logins
  • Confirm VXPRTsvc_vra_iaas is listed, right click on that user and select Properties
  • Click on Server Roles and ensure sysadmin is selected

 

SQL Server sysadmin permission for vCAC / vRA Service account

SQL Server sysadmin permission for vCAC / vRA Service account

  • Close Management Studio
  • Open the Start menu and type SQL Server Configuration Manager
  • Expand SQL Server network Configuration
  • Right click on TCP/IP and select enable; click OK when prompted
  • Click on SQL Server Services
  • Right click on SQL Server (MSSQLSERVER) and select Restart
  • On the Start menu and type Services
  • Ensure Distributed Transaction Coordinator is set for Automatic or Automatic (Delayed Start)
  • Close Services

With SQL installed and our user account having sysadmin permission on the SQL server, its time to install the IaaS components!  Log out of the IaaS server and we’ll pick this up in the next post.

Install vRealize Automation IaaS SQL 2014 Installation – vRealize Automation Series Part 5