Adventures with vCloud Director, Part I

Now that I have a little free time post-VCP5, I will be working on vCloud Director (vCD).

I am not an Oracle expert, but I did try to deploy my vCloud Database on Oracle.  I ran into some roadblocks with obtaining the required libraries.  So, the Oracle experiment is on hold while I move forward with Microsoft SQL 2008.

While building the vCloud Database, I created an SQL script, based on the vCD Installation Guide, to use with SQL Server’s query tools if you prefer to use SQL statements.  The Transact-SQL Statements will be included below.  If you prefer to use the SQL Server Database Creation GUI, Kendrick Coleman has a great article on his blog (click his name to access the article).

Another obstacle that I’m working through is the Certificate requirement.  I do not work with certificates on a regular basis, and I’m still working on generating my certificates correctly.  Once I complete that step, I’ll post an update with my progress.

For now, here are the Transact-SQL statements for creating the vCloud Database:
STANDARD DISCLAIMER: The SQL statements below  are provided for reference only.  Do not use in production.  There is no support provided either by myself or my employer.  Various other legal jargon, blah, blah, blah.

P.S. The N prefix used with the values below is used to indicate Unicode.  You can find more details at this article.
/* Step 1: Create Database */
use [master]
GO
CREATE DATABASE [vcloud] ON PRIMARY (NAME = N'vcloud', FILENAME = N'C:\vcloud.mdf', SIZE = 100MB, FILEGROWTH = 10%)
LOG ON
(NAME = N'vcdb.log', FILENAME = N'C:\vcloud.ldf', SIZE = 1MB, FILEGROWTH = 10%) COLLATE Latin1_General_CS_AS
GO

/* Step 2: Configure DB Settings */
USE [vcloud]
GO
ALTER DATABASE [vcloud] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [vcloud] SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE [vcloud] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
ALTER DATABASE [vcloud] SET MULTI_USER;
GO

/* Step 3: Create vcloudMgr user */
USE [vcloud]
GO
CREATE LOGIN [vcloudMgr] WITH PASSWORD = 'yourpassword', DEFAULT_DATABASE = [vcloud], DEFAULT_LANGUAGE = [us_english], CHECK_POLICY=OFF
GO
CREATE USER [vcloudMgr] for LOGIN [vcloudMgr]
GO

/* Step 4: Set vcloudMgr permissions on database */
USE [vcloud]
GO
sp_addrolemember [db_owner], [vcloudMgr]
GO

Leave a Reply

Your email address will not be published. Required fields are marked *