Install And Configure SQL Server
This article will demonstrate the process of setting up a instance of SQL Server on the IaaS host Windows Virtual Machine.
Please note: Because I’m going to install SQL Server Express on the IaaS host, the following requirements have to be considered additionally, as you can read in the official documentation:
- „A 64-bit version of Java 1.7 or later must be installed. 32-bit versions are not supported“
- „The JAVA_HOME environment variable must be set to the Java installation folder“
- „The %JAVA_HOME%\bin\java.exe file must be available“
- The service SQL Server Browser must be installed and running
Using SQL Server Express for the minimal deployment option in a test environment is absolutely fine.
But when setting up a production environment, you should check the limitations of the Express edition first.
Microsoft offers a bunch of download options for SQL Server 2014 Express.
As a precaution, I chose the full-featured installation including tools and advanced services, which is labeled
ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe and has a file size of 1.1 GB.
5. Install SQL Server Express 2014
5.1 After starting the installation, choose New SQL Server stand-alone installation or add features to an existing installation
5.2 Accept the license agreement and optionally enable the Customer Experience Improvement Program
5.4 In step Instance Configuration, you have the option to install a default or named instance. Both options should work fine. I chose the named instance „SQLExpress“
5.6 On the Database Engine Configuration page, choose Mixed Mode as Authentication Mode. Provide a strong System Administrator password and make sure that your current user (see 1.1) is listed as SQL Server administrator
5.7 Optionally install or install and configure the Reporting Services
5.8 Finish installation
6. Configure SQL Server
6.1 Open SQL Server Management Studio
6.7 Verify that the Service SQL Server Browser is running and close Services
6.9 Close Component Services
The next part describes how to install the IaaS Management Agent and guides you through the vRA 7 Installation Wizard.