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.
- Click New SQL Server stand-alone installation or add features to an existing installation
- Check all the tests have passed
- Click next on the product updates page, SQL will download any new updates from Microsoft.
- Click Install on set-up files
- Check that all issues are green, in this case you can see that the windows firewall needs to be disabled or have ports open.
- 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).
- Re-Run the tests and click next once all are passed click Next.
- Enter the license key and click Next
- Accepte the EULA and click Next
- Select SQL Server Feature installation
- 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.
- Confirm there are no issues with the Installation Rules
- Select the instance configuration, I will be using the Default Instance for all the databases in this lab.
- Confirm disk space requirements are met
- 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.
- 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.
- Data Directories can also be specified to split Database and Log directories.
- Optionally allow error reports to be sent to Microsoft.
- Click next on another rules check
- Finally Click Install
- Wait for the installation to complete
- Click Close once complete
- Next step is to configure, select SQL Server Configuration Manager from the Start Menu
- Ensure that TCP/IP Is enabled for our instance “MSSQLSEVER”
- Next launch Component Services using search or Control Panel –> Administrative Tools –> Component Services.
- Expand Component services –> Computers –> My Computer –> Distributed Transaction Coordinator. Right Click Local DTC and click Properties.
- Click the Security Tab, Click Allow Remote Clients, Allow Inbound, Allow Outbound, and click Apply
- Click Yes
- 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.