10: View Composer

Create an VM for View Composer

$vm = Get-ResourcePool -Location Servers | New-VM -Name "VCMP01" -DiskGB 30 -MemoryGB 2 -NumCpu 2 -CD -NetworkName "VM Network" -GuestId windows8Server64Guest
Get-NetworkAdapter $vm | Set-NetworkAdapter -Type Vmxnet3 -Confirm:$false
Get-ScsiController $vm | Set-ScsiController -Type ParaVirtual -Confirm:$false
Start-VM $vm | Open-VMConsoleWindow -FullScreen

Install Windows 2012 R2 using MDT.

Set the IP address and DNS server

New-NetIPAddress -InterfaceAlias "Ethernet0" -IPAddress 10.0.1.10 -PrefixLength 16 -DefaultGateway 10.0.0.1
Set-DnsClientServerAddress -InterfaceAlias "Ethernet0" -ServerAddresses 10.0.1.5

Install .Net 3.5.1 which requires the server ISO which should still be mounted at this point

Add-WindowsFeature Net-Framework-Core -Source D:\Sources\sxs

Download Microsoft SQL Express 2012 with SP2. You need file SQLEXPR_x64_ENU.exe. The installation command line is given below – all the defaults except for turning on TCP support

SQLEXPR_x64_ENU.exe /QS /ACTION=install /INSTANCENAME=SQLEXPRESS /SAPWD=** /SECURITYMODE=SQL /SQLSVCSTARTUPTYPE=Automatic /SQLSYSADMINACCOUNTS="MYLAB\Domain Admins" /SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS=1

Progress screen

image

Unfortunately, the you can’t seem to specify the TCP static port on the command line and it defaults to dynamic ports.

Open SQL Server Configuration Manager and expand SQL Server Network Configuration in the left pane and click on Protocols for SQLEXPRESS.  In the right hand pane click on TCP/IP with the right hand mouse button and choose Properties.  Switch to the IP Addresses tab and scroll right to the bottom.  In the section IPAll set the TCP Dynamic Ports entry to blank and set TCP Port to 1433 as shown below

image

Now click on SQL Server Services in the left hand pane and in the right hand pane click on SQL Server (SQLExpress) with the right hand mouse button and choose Restart

By default the local firewall blocks inbound connections to 1433 so we need to create a firewall rule to allow them

New-NetFirewallRule -DisplayName "SQL Database Engine" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow

Open osql which can be found in C:\Program Files\Microsoft SQL Server\110\Tools\Binn

Run through the commands below which create a new database call ViewCompose and a user called vcmpuser with access to the database

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>osql -E
1> create database ViewComposer;
2> go
1> use ViewComposer;
2> go
1> create login [vcmpuser] with password=N'vcmpuser!0', default_database=ViewComposer, default_language=us_english, check_policy=off
2> go
1> create user [vcmpuser] for login [vcmpuser]
2> go
1> sp_addrolemember [db_owner], [vcmpuser]
2> go
1> use msdb
2> go
1> create user [vcmpuser] for login [vcmpuser]
2> go
1> quit

Amusingly you can create the DSN via the command line however you can’t set any of the parameters that you’d really want to so eventually you’ll end up in Control Panel and ODBC Data Source Administrator (64 bit)

odbcconf CONFIGSYSDSN "SQL Server Native Client 11.0" "DSN=ViewComposer|Server=VCMP01"

Configure the connection (perhaps you don’t need to do this but the great bit is the Test button at the end to show that you’ve done things correctly)

imageimageimageimageimage

Open the View Composer installer VMware-viewcomposer-6.1.1-2768165.exe it’s mostly the defaults through the installation but remember to use the existing machine SSL certificate rather than creating a default one

imageimageimageimageimageimageimage

This is a huge moment as we can connect VCSA, VCS and View Composer together.  Open View Administrator and in the left hand pane expand View Configuration and then click on Servers.  Under vCenter Server click on Add and complete the wizard.  The default number of concurrent operations are very optimistic for my lab but I’m going to leave them

image

Select the Standalone Composer option

image

Add the Windows AD Domain

image

I’ve turned off both Reclaim VM and Storage Accelerator as in my experience neither helps very much but your mileage may vary

image

Complete the wizard

image