As part of a project I am currently working on, I started to deploy vCD in my home lab for further integration with other EMC and VMware products. I would like to share the steps required to deploy vCD, I believe it is the only VMware products that comes in .bin format and not packaged as OVA like other products provided by VMware. I will list all steps required in case you need to test it in your lab…
So let us first check the compatibility matrix for vCD:
1- My lab runs MSSQL 2012 Express
3- I will be using CentOS 6.4 in Desktop mode. (KB2059451)
In this post I will be talking about MSSQL DB configuration for vCD. In the next posts I will be talking about CentOS installation following by the last post for vCD installation.
So let us start with MSSQL…
1- Download the MSSQL2012 Express for free from MS.
2- Go through the installation on your server (My server is win2k8 R2 x64). Click finish once the installation completes.
3- From Start Menu Open –> All Programs –> Microsoft SQL server 2012 –> SQL server and Management Studio.
6- Now it is time to create the database, Right click database tab and then click “New database”
7- Give the database a name, then under database files change the initial size for Rows data and log files to 1024MB and 128 receptively.
8- From Autogrowth/Maxsize Enable Autogrwoth check box. For Rows data, Set File growth to 512 MB, Max file Size 4096MB. For log file, Enable Autogrowth check box, File Growth should be set to 128 MB and maximum File Size is 1024 MB.
10- Go to general tab and change the collation to Latin1_General_100_CS_AS then click OK.
11- Now we should run a new query on the database. I am using the same script mentioned in Kendrick Coleman blog post.
ALTER DATABASE [vcloud] SET RECOVERY SIMPLE;
ALTER DATABASE [vcloud] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [vcloud] SET ALLOW_SNAPSHOT_ISOLATION ON;
EXEC sp_addextendedpoperty @name = N'ALLOW_SNAPSHOT_ISOLATION', @value = 'ON';
ALTER DATABASE [vcloud] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
EXEC sp_addextendedproperty @name = N'READ_COMMITTED_SNAPSHOT', @value = 'ON';
ALTER DATABASE [vcloud] SET MULTI_USER;
12- The last step will be to configure the connections, so you will need to open sql server connection manager—> Expand SQL server network connection then Click on TCP/IP and from change the status to Enabled.
13- Go to Ip addresses tab and scroll down to IPAll setting and set the TCP port to 1433.
Now your database is ready. In the next part I will cover the CentOS installation. Stay tuned…