slideshow 6 slideshow 4 slideshow 8 slideshow 1 slideshow 2 slideshow 3 slideshow 5 slideshow 7

Preparing SQL Server Express for a vRealize Automation 7 Proof of Concept Setup

For a vRealize Automation 7 deployment including Infrastructure As A Service (IAAS) a Microsoft SQL database server is a requirement. Not everyone has access to that software and when setting up a Proof of Concept environment it is not always justifiable to purchase a SQL Server license. Therefor in the case of a PoC it's a viable solution to use SQL Express.

As you can read in the vRealize Automation Support Matrix (vRealize Automation 7 Documentation) you need SQL Server 2008 / 2012 / 2014 but Express versions are not supported. So for a production environment the setup in this article is not a supported configuration.

There are a few requirements for your database server setup. They are described here: vRealize Automation 7 Documentation Database Requirements. It is however also necessary to enable a few more features to allow SQL Express to be used for your IAAS deployment. Short: Enable TCP/IP, Named pipes and configure the TCP-port to 1433. These steps are described below.

First of all download SQL Express from the Microsoft Website and install it on your server. For this article I have used Windows Server 2008 R2 SP with the SQL Express 2008 R2 Express software. I have installed the SQL Express software in the same host that will be used for the other IAAS components.

vRealize 7 SQL Express Setup

During the installation I have not changed any of the features, so this screenshot contains all the default settings that Microsoft provides.

vRealize 7 SQL Express Setup

vRealize 7 SQL Express Setup

Set the SQL Server Browser to Automatic.

vRealize 7 SQL Express Setup

Provide a user account that will be the administrative user of you SQL deployment. If you use a vRealize Automation service account, such as DOMAIN\VRA-IAAS then you could also use that account as a database administrator.

vRealize 7 SQL Express Setup

After the installation completes open the SQL Server Configuration Manager from the Start menu. Open the SQL Server Network Configuration, select the Protocols entry and enable Named Pipes and TCP/IP.

vRealize 7 SQL Express Setup

Next right click the TCP/IP entry and modify the properties. Change the TCP Port for the bound IP Address to 1433.

vRealize 7 SQL Express Setup

Also change the TCP Port for the IPAll configuration to 1433.

vRealize Automation 7 SQL Express Setup

After making these modifications restart the SQL Server service.

vRealize 7 SQL Express Setup

Your database server is now ready and a database will be able to be created during installation of vRealize Automation 7.

 

 

 

getting started tags: 
Follow us on LinkedIn