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:
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 64BITSQLEXPRADV_x64_ENU.exe and has a file size of 1.1 GB.
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.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.