Install Microsoft SQL Server 2012 for vRealize Automation

Install Microsoft SQL Server 2012 for vRealize Automation

This will walk you through a single server install of MS SQL Server 2012 for my lab environment, this would also be acceptable for a POC or Dev environment but any production environment should use SQL clustering to ensure resiliency.

If you are familiar with the installation you can skip to Configuration.

Install SQL

  1. Click New SQL Server stand-alone installation or add features to an existing installation
  2. Check all the tests have passed

  3. Click next on the product updates page, SQL will download any new updates from Microsoft.

  4. Click Install on set-up files

  5. Check that all issues are green, in this case you can see that the windows firewall needs to be disabled or have ports open.

  6. Disable Windows Firewall from Control Panel –> System and Security –> Windows Firewall. Alternatively allow the required ports in your third party firewall (As this is a lab its easier to disable the firewall).

  7. Re-Run the tests and click next once all are passed click Next.

  8. Enter the license key and click Next

  9. Accepte the EULA and click Next

  10. Select SQL Server Feature installation
    SQL Server Setup Role

    SQL Server Setup Role

  11. Select the SQL features. We need the Database Engine Services as the core, Production would use SQL Replication, and we also need the Management tools. You can also specify the installation path here.
    Select  Required SQL Server Roles

    Select Required SQL Server Roles

  12. Confirm there are no issues with the Installation Rules

  13. Select the instance configuration, I will be using the Default Instance for all the databases in this lab.
    SQL Instance

    SQL Instance

  14. Confirm disk space requirements are met
    Disk Space Requirements

    Disk Space Requirements

  15. I have set up a service account “LAB\svc_sql” in Active Directory for SQL and have specified that here, I have also set Automatic Startup.
    SQL Service Accounts

    SQL Service Accounts

  16. Database Engine Configuration is fairly important, as below you can specify either Windows or Mixed Mode authentication, and administrators need to be specified, as you can see I have given my service account, the administrator, and a group which would usually be a SQL Admins group in Production.
    SQL Database Engine Configuration 1

    SQL Database Engine Configuration 1

  17. Data Directories can also be specified to split Database and Log directories.
    SQL Database Engine Configuration 2

    SQL Database Engine Configuration 2

  18. Optionally allow error reports to be sent to Microsoft.
    SQL Error Reporting

    SQL Error Reporting

  19. Click next on another rules check
    Installation Rules Check

    Installation Rules Check

  20. Finally Click Install
    SQL Ready to Install

    SQL Ready to Install

  21. Wait for the installation to complete
    Installation Progress

    Installation Progress

  22. Click Close once complete

Configuration

  1. Next step is to configure, select SQL Server Configuration Manager from the Start Menu

  2. Ensure that TCP/IP Is enabled for our instance “MSSQLSEVER

  3. Next launch Component Services using search or Control Panel –> Administrative Tools –> Component Services.

  4. Expand Component services –> Computers –> My Computer –> Distributed Transaction Coordinator. Right Click Local DTC and click Properties.

  5. Click the Security Tab, Click Allow Remote Clients, Allow Inbound, Allow Outbound, and click Apply

  6. Click Yes 

  7. Click Start, and type Services.msc confirm that Distributed Transaction Coordinator, and all SQL services are set to Auto, or Auto Delayed start.

You are now ready to install vRA IaaS.