<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en-GB">
	<id>http://vwiki.co.uk/index.php?action=history&amp;feed=atom&amp;title=Installation_vSphere_5_%28vCentre%29</id>
	<title>Installation vSphere 5 (vCentre) - Revision history</title>
	<link rel="self" type="application/atom+xml" href="http://vwiki.co.uk/index.php?action=history&amp;feed=atom&amp;title=Installation_vSphere_5_%28vCentre%29"/>
	<link rel="alternate" type="text/html" href="http://vwiki.co.uk/index.php?title=Installation_vSphere_5_(vCentre)&amp;action=history"/>
	<updated>2026-05-20T08:41:07Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.43.6</generator>
	<entry>
		<id>http://vwiki.co.uk/index.php?title=Installation_vSphere_5_(vCentre)&amp;diff=2259&amp;oldid=prev</id>
		<title>Sstrutt: /* Installation */ Added VMware vSphere Web Client install</title>
		<link rel="alternate" type="text/html" href="http://vwiki.co.uk/index.php?title=Installation_vSphere_5_(vCentre)&amp;diff=2259&amp;oldid=prev"/>
		<updated>2013-02-04T20:28:53Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;Installation: &lt;/span&gt; Added VMware vSphere Web Client install&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en-GB&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 20:28, 4 February 2013&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l209&quot;&gt;Line 209:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 209:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# If required, change the &amp;#039;&amp;#039;Destination Folder&amp;#039;&amp;#039;, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# If required, change the &amp;#039;&amp;#039;Destination Folder&amp;#039;&amp;#039;, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* Its common to install to a seperate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* Its common to install to a seperate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Click &#039;&#039;&#039;Install&#039;&#039;&#039; to complete the installation&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;=== Web Client ===&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Select &#039;&#039;VMware vSphere Web Client&#039;&#039; from the installer menu, and click &#039;&#039;&#039;Install&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;#* Click &#039;&#039;&#039;Allow&#039;&#039;&#039; or &#039;&#039;&#039;Continue&#039;&#039;&#039; if you get a &#039;&#039;User Account Control&#039;&#039; warning&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Change the installer language if required, then click &#039;&#039;&#039;OK&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Click &#039;&#039;&#039;Next&#039;&#039;&#039; at both the &#039;&#039;VMware vSphere Web Client&#039;&#039; install start, and &#039;&#039;End User Patent Agreement&#039;&#039; screens&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Accept [[Acronyms#E|EULA]], and then click &#039;&#039;&#039;Next&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# If required, change the &#039;&#039;Destination Folder&#039;&#039;, then click &#039;&#039;&#039;Next&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;#* Its common to install to a seperate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Accept the default TCP ports (its recommended that you don&#039;t share the server with other services which, for example, might necessitate changing the ports), and then click &#039;&#039;&#039;Next&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;# Enter the password for the SSO admin account (created in SSO install), and then click &#039;&#039;&#039;Next&#039;&#039;&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039; to complete the installation&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039; to complete the installation&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Sstrutt</name></author>
	</entry>
	<entry>
		<id>http://vwiki.co.uk/index.php?title=Installation_vSphere_5_(vCentre)&amp;diff=2239&amp;oldid=prev</id>
		<title>Sstrutt: Initial creation</title>
		<link rel="alternate" type="text/html" href="http://vwiki.co.uk/index.php?title=Installation_vSphere_5_(vCentre)&amp;diff=2239&amp;oldid=prev"/>
		<updated>2013-01-15T14:52:44Z</updated>

		<summary type="html">&lt;p&gt;Initial creation&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;vCentre comprises of the following components.  These can be installed on the same machine, or if required (in larger environments) on separate machines.  However, they must be installed in the order specified.&lt;br /&gt;
# vCentre Single Sign On (SSO)&lt;br /&gt;
# VMware vCentre Inventory Service&lt;br /&gt;
# VMware vCentre Server&lt;br /&gt;
# VMware vSphere Update Manager&lt;br /&gt;
&lt;br /&gt;
These notes were made using the vSphere v5.1a ISO, and assumes everything is being installed on the same server.  You can either select the &amp;#039;&amp;#039;VMware vCenter Simple Install&amp;#039;&amp;#039; install, which will install SSO, Inventory and then vCentre Server, or select the component individually.&lt;br /&gt;
&lt;br /&gt;
== Requirements ==&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;Database&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
** Selected Microsoft SQL, IBM DB2 and Oracle databases&lt;br /&gt;
** See http://partnerweb.vmware.com/comp_guide2/sim/interop_matrix.php&lt;br /&gt;
** For instructions see the [[MS_SQL#SQL_2008_Standard#MS SQL 2008 Install]]&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;Operating System&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
** Windows Server 2003 64-bit (Standard, Enterprise or Datacenter; SP2 or R2)&lt;br /&gt;
** Windows Server 2008 64-bit (Standard, Enterprise or Datacenter; SP1, SP2, R2, R2 SP1)&lt;br /&gt;
&lt;br /&gt;
== Database Set-up ==&lt;br /&gt;
== Create vCentre Database ==&lt;br /&gt;
These instructions are for creating a vCentre database on MS SQL 2008 (other variants of MS SQL will be similar, but these notes will be of no use if you&amp;#039;re using IBM DB2 or Oracle).&lt;br /&gt;
&lt;br /&gt;
For more information see [http://pubs.vmware.com/vsphere-50/topic/com.vmware.vsphere.install.doc_50/GUID-36B92A8C-074A-4657-9938-62AB97225B91.html the VMware documentation]&lt;br /&gt;
&lt;br /&gt;
# Start &amp;#039;&amp;#039;SQL Server Management Studio&amp;#039;&amp;#039; on your SQL server and login as a SQL administrator&lt;br /&gt;
# Create the database&lt;br /&gt;
## Right-click over &amp;#039;&amp;#039;Databases&amp;#039;&amp;#039; and select &amp;#039;&amp;#039;&amp;#039;New Database...&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
## In &amp;#039;&amp;#039;General&amp;#039;&amp;#039; set the database name to &amp;lt;code&amp;gt;VCDB&amp;lt;/code&amp;gt; (or something else of your choosing)&lt;br /&gt;
## Go to &amp;#039;&amp;#039;Options&amp;#039;&amp;#039; set the &amp;#039;&amp;#039;Recovery model&amp;#039;&amp;#039; to &amp;#039;&amp;#039;&amp;#039;Simple&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
## Then click on &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039; to create the database&lt;br /&gt;
# Create the vCentre user&lt;br /&gt;
## Right-click over &amp;#039;&amp;#039;Security&amp;#039;&amp;#039; and select &amp;#039;&amp;#039;&amp;#039;New &amp;gt; Login&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
## In &amp;#039;&amp;#039;General&amp;#039;&amp;#039; set the &amp;#039;&amp;#039;Login name:&amp;#039;&amp;#039; to &amp;lt;code&amp;gt;vpxuser&amp;lt;/code&amp;gt;, select &amp;#039;&amp;#039;SQL Server authentication&amp;#039;&amp;#039;, and create a password, and untick the following&lt;br /&gt;
##* &amp;#039;&amp;#039;Enforce password policy&amp;#039;&amp;#039;&lt;br /&gt;
##* &amp;#039;&amp;#039;Enforce password expiration&amp;#039;&amp;#039;&lt;br /&gt;
##* &amp;#039;&amp;#039;User must change password at next login&amp;#039;&amp;#039;&lt;br /&gt;
## Set the &amp;#039;&amp;#039;Default database&amp;#039;&amp;#039; to &amp;lt;code&amp;gt;VCDB&amp;lt;/code&amp;gt; (or whatever you called your database)&lt;br /&gt;
## Set the &amp;#039;&amp;#039;Default language&amp;#039;&amp;#039; to &amp;lt;code&amp;gt;English&amp;lt;/code&amp;gt; (not &amp;#039;&amp;#039;British English&amp;#039;&amp;#039;, using (American) English is safer, though obviously wrong)&lt;br /&gt;
## Go to &amp;#039;&amp;#039;User Mapping&amp;#039;&amp;#039;, check the &amp;#039;&amp;#039;Map&amp;#039;&amp;#039; option for &amp;#039;&amp;#039;msdb&amp;#039;&amp;#039; and check the &amp;lt;code&amp;gt;db_owner&amp;lt;/code&amp;gt; role membership below, then do the same for &amp;#039;&amp;#039;VCDB&amp;#039;&amp;#039;&lt;br /&gt;
## Then click on &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039; to create the user&lt;br /&gt;
## Click on the &amp;#039;&amp;#039;New Query&amp;#039;&amp;#039; button, and enter the following&lt;br /&gt;
##* &amp;lt;code&amp;gt; GRANT VIEW SERVER STATE TO vpxuser &amp;lt;/code&amp;gt;&lt;br /&gt;
##* &amp;lt;code&amp;gt; GO &amp;lt;/code&amp;gt;&lt;br /&gt;
## Then click on the &amp;#039;&amp;#039;&amp;#039;! Execute&amp;#039;&amp;#039;&amp;#039; button&lt;br /&gt;
&lt;br /&gt;
== Create SSO Database ==&lt;br /&gt;
# Mount the vCenter install ISO on the machines CD Drive&lt;br /&gt;
# Start &amp;#039;&amp;#039;SQL Server Management Studio&amp;#039;&amp;#039; on your SQL server and login as a SQL administrator&lt;br /&gt;
# Create the database&lt;br /&gt;
## Go to &amp;#039;&amp;#039;File | Open | File...&amp;#039;&amp;#039; and open the following SQL script on the CD Drive&lt;br /&gt;
##* &amp;lt;code&amp;gt; Single Sign On\DBScripts\SSOServer\schema\mssql\rsaIMSLiteMSSQLCreateSchema &amp;lt;/code&amp;gt;&lt;br /&gt;
## Edit the file to ensure that the file locations for you databases are correct (see example below)&lt;br /&gt;
## Click &amp;#039;&amp;#039;&amp;#039;! Execute&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Create the SSO database user accounts&lt;br /&gt;
## Right-click over &amp;#039;&amp;#039;Security&amp;#039;&amp;#039; and select &amp;#039;&amp;#039;&amp;#039;New &amp;gt; Login&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
## In &amp;#039;&amp;#039;General&amp;#039;&amp;#039; set the &amp;#039;&amp;#039;Login name:&amp;#039;&amp;#039; to &amp;lt;code&amp;gt;SSO_DBA&amp;lt;/code&amp;gt;, select &amp;#039;&amp;#039;SQL Server authentication&amp;#039;&amp;#039;, create a password, and untick the following&lt;br /&gt;
##* &amp;#039;&amp;#039;Enforce password policy&amp;#039;&amp;#039;&lt;br /&gt;
##* &amp;#039;&amp;#039;Enforce password expiration&amp;#039;&amp;#039;&lt;br /&gt;
##* &amp;#039;&amp;#039;User must change password at next login&amp;#039;&amp;#039;&lt;br /&gt;
## Set the &amp;#039;&amp;#039;Default database&amp;#039;&amp;#039; to &amp;lt;code&amp;gt;SSO&amp;lt;/code&amp;gt; (or whatever you called your database)&lt;br /&gt;
## Then click on &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039; to create the user&lt;br /&gt;
## Then repeat the above for another user, &amp;lt;code&amp;gt;SSO_User&amp;lt;/code&amp;gt;&lt;br /&gt;
# Give &amp;#039;&amp;#039;SSO_DBA&amp;#039;&amp;#039; rights over schema&lt;br /&gt;
## Browse to &amp;#039;&amp;#039;Databases &amp;gt; SSO &amp;gt; Security &amp;gt; Users&amp;#039;&amp;#039;&lt;br /&gt;
## Right-click over &amp;#039;&amp;#039;SSO_DBA&amp;#039;&amp;#039; and select &amp;#039;&amp;#039;&amp;#039;Properties&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
## In &amp;#039;&amp;#039;Schemas owned by this user:&amp;#039;&amp;#039; check &amp;lt;code&amp;gt;db_owner&amp;lt;/code&amp;gt;, then click &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039; to apply&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
-- PROJECT     IMS&lt;br /&gt;
-- MODEL       IDENTITY MANAGEMENT SERVICE&lt;br /&gt;
-- COMPANY     RSA, the Security Division of EMC&lt;br /&gt;
-- DATABASE    MSSQL&lt;br /&gt;
&lt;br /&gt;
USE MASTER&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
-------------------------------------------------------------------------------------&lt;br /&gt;
-- Create database&lt;br /&gt;
--&lt;br /&gt;
-- Using this script is not mandatory. The database can be created with&lt;br /&gt;
-- SQL Management Studio, ensuring that there are two tablespaces, named RSA_DATA&lt;br /&gt;
-- and RSA_INDEX, and that there are only alphanumeric characters in the database name.&lt;br /&gt;
--&lt;br /&gt;
-- Before running this script, customize the file paths (CHANGE ME) below.&lt;br /&gt;
-- 1. Decide on a folder to hold the database files (10 GB of space required).&lt;br /&gt;
-- For example, it can be the DATA folder of the SQL Server, usually&lt;br /&gt;
-- C:\Program Files\Microsoft SQL Server\MSSQL10_50.&amp;lt;instance name&amp;gt;\MSSQL\DATA&lt;br /&gt;
-- 2. Replace all 3 occurrences of C:\CHANGE ME with the path to the folder&lt;br /&gt;
&lt;br /&gt;
-- The database name can also be customized, but it is forbidden to include&lt;br /&gt;
-- reserved keywords like database or any characters other than letters, numbers,&lt;br /&gt;
-- _, @ and #.&lt;br /&gt;
&lt;br /&gt;
-- Advanced users can put the different files (RSA_DATA, RSA_INDEX and LOG)&lt;br /&gt;
-- on different storage devices to improve performance. RSA_INDEX is a small file which&lt;br /&gt;
-- is recommended to be stored on a fast device.&lt;br /&gt;
-- For more details, please refer to Microsoft documentation at http://technet.microsoft.com/en-us/library/ms143547.aspx&lt;br /&gt;
-------------------------------------------------------------------------------------&lt;br /&gt;
CREATE DATABASE SSO ON PRIMARY(&lt;br /&gt;
    NAME=&amp;#039;RSA_DATA&amp;#039;,&lt;br /&gt;
    FILENAME=&amp;#039;D:\MS SQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\SSO_DATA.mdf&amp;#039;,&lt;br /&gt;
    SIZE=10MB,&lt;br /&gt;
    MAXSIZE=UNLIMITED,&lt;br /&gt;
    FILEGROWTH=10%),&lt;br /&gt;
FILEGROUP RSA_INDEX(&lt;br /&gt;
    NAME=&amp;#039;RSA_INDEX&amp;#039;,&lt;br /&gt;
    FILENAME=&amp;#039;D:\MS SQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\SSO_INDEX.ndf&amp;#039;,&lt;br /&gt;
    SIZE=10MB,&lt;br /&gt;
    MAXSIZE=UNLIMITED,&lt;br /&gt;
    FILEGROWTH=10%)&lt;br /&gt;
LOG ON(&lt;br /&gt;
    NAME=&amp;#039;translog&amp;#039;,&lt;br /&gt;
    FILENAME=&amp;#039;D:\MS SQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\SSO_log.ldf&amp;#039;,&lt;br /&gt;
    SIZE=10MB,&lt;br /&gt;
    MAXSIZE=UNLIMITED,&lt;br /&gt;
    FILEGROWTH=10% )&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
-- Set recommended perform settings on the database&lt;br /&gt;
EXEC SP_DBOPTION &amp;#039;SSO&amp;#039;, &amp;#039;autoshrink&amp;#039;, true&lt;br /&gt;
GO&lt;br /&gt;
EXEC SP_DBOPTION &amp;#039;SSO&amp;#039;, &amp;#039;trunc. log on chkpt.&amp;#039;, true&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
CHECKPOINT&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
-------------------------------------------------------------------------------------&lt;br /&gt;
-- To drop the database, the commands is:&lt;br /&gt;
-------------------------------------------------------------------------------------&lt;br /&gt;
-- DROP DATABASE RSA&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Installation ==&lt;br /&gt;
=== Single Sign On ===&lt;br /&gt;
Before starting the install, ensure you have set-up...&lt;br /&gt;
* [[#Create SSO Database|SSO Database]]&lt;br /&gt;
&lt;br /&gt;
# Start the installer&lt;br /&gt;
# Select &amp;#039;&amp;#039;vCenter Single Sign On&amp;#039;&amp;#039;, and click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Click &amp;#039;&amp;#039;&amp;#039;Allow&amp;#039;&amp;#039;&amp;#039; or &amp;#039;&amp;#039;&amp;#039;Continue&amp;#039;&amp;#039;&amp;#039; if you get a &amp;#039;&amp;#039;User Account Control&amp;#039;&amp;#039; warning&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039; at both the &amp;#039;&amp;#039;vCenter Single Sign On&amp;#039;&amp;#039; install start, and &amp;#039;&amp;#039;End User Patent Agreement&amp;#039;&amp;#039; screens&lt;br /&gt;
# Accept [[Acronyms#E|EULA]], and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Enter a password for the SSO admin account &lt;br /&gt;
# Select &amp;#039;&amp;#039;Use an existing supported database&amp;#039;&amp;#039;, and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Populate the &amp;#039;&amp;#039;Database Information&amp;#039;&amp;#039; as follows, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* &amp;#039;&amp;#039;Database Name:&amp;#039;&amp;#039; &amp;lt;code&amp;gt;SSO&amp;lt;/code&amp;gt;&lt;br /&gt;
#* &amp;#039;&amp;#039;Host name or IP address:&amp;#039;&amp;#039; &amp;lt;code&amp;gt;localhost&amp;lt;/code&amp;gt; (assuming database has been installed locally)&lt;br /&gt;
#* &amp;#039;&amp;#039;Database user name:&amp;#039;&amp;#039; &amp;lt;code&amp;gt;SSO_User&amp;lt;/code&amp;gt;&lt;br /&gt;
#* &amp;#039;&amp;#039;Database password:&amp;#039;&amp;#039; [as created for &amp;#039;&amp;#039;SSO_User&amp;#039;&amp;#039;]&lt;br /&gt;
#* &amp;#039;&amp;#039;Database DBA user name:&amp;#039;&amp;#039; &amp;lt;code&amp;gt;SSO_DBA&amp;lt;/code&amp;gt;&lt;br /&gt;
#* &amp;#039;&amp;#039;Database DBA password:&amp;#039;&amp;#039; [as created for &amp;#039;&amp;#039;SSO_DBA&amp;#039;&amp;#039;]&lt;br /&gt;
# Check the system name (or IP address) is correct, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* You may get a popup complaining the [[Acronyms#F|FQDN]] cannot be resolved, double-check with &amp;lt;code&amp;gt;nslookup&amp;lt;/code&amp;gt; manually, performing both forward and reverse lookups&lt;br /&gt;
# Leave &amp;#039;&amp;#039;Use network service account&amp;#039;&amp;#039; checked, and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# If required, change the &amp;#039;&amp;#039;Destination Folder&amp;#039;&amp;#039;, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Its common to install to a separate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;br /&gt;
# Leave &amp;#039;&amp;#039;HTTPS port&amp;#039;&amp;#039; as is, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;, the &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039; to commence installation&lt;br /&gt;
&lt;br /&gt;
=== Inventory Service ===&lt;br /&gt;
# Select &amp;#039;&amp;#039;VMware vCentre Inventory Service&amp;#039;&amp;#039; from the installer menu, and click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Click &amp;#039;&amp;#039;&amp;#039;Allow&amp;#039;&amp;#039;&amp;#039; or &amp;#039;&amp;#039;&amp;#039;Continue&amp;#039;&amp;#039;&amp;#039; if you get a &amp;#039;&amp;#039;User Account Control&amp;#039;&amp;#039; warning&lt;br /&gt;
# Change the installer language if required, then click &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039; at both the &amp;#039;&amp;#039;VMware vCentre Inventory Service&amp;#039;&amp;#039; install start, and &amp;#039;&amp;#039;End User Patent Agreement&amp;#039;&amp;#039; screens&lt;br /&gt;
# Accept [[Acronyms#E|EULA]], and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# If required, change the &amp;#039;&amp;#039;Destination Folder&amp;#039;&amp;#039;, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Its common to install to a separate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;br /&gt;
# Check the system name (or IP address) is correct, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* You may get a popup complaining the FQDN cannot be resolved, double-check with &amp;lt;code&amp;gt;nslookup&amp;lt;/code&amp;gt; manually, performing both forward and reverse lookups&lt;br /&gt;
# Unless required, leave TCP ports as is, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Select the appropriate &amp;#039;&amp;#039;Inventory Size&amp;#039;&amp;#039; for your environment, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* If you expect your infrastructure to grow, and you have sufficient memory available, then use what you expect your final inventory size to be&lt;br /&gt;
# Enter the password for the SSO admin account (created in SSO install), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* If you installed SSO on a different server, you&amp;#039;ll also need to update the &amp;#039;&amp;#039;Lookup service URL&amp;#039;&amp;#039;&lt;br /&gt;
# If you get a screen regarding &amp;#039;&amp;#039;Certificate Installation for Secure Connection&amp;#039;&amp;#039;, click on &amp;#039;&amp;#039;&amp;#039;Install certificates&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039; to complete installation&lt;br /&gt;
&lt;br /&gt;
=== vCentre Server ===&lt;br /&gt;
Before starting the install, ensure you have set-up both...&lt;br /&gt;
* [[#Create vCentre Database|VCentre Database]]&lt;br /&gt;
* [[Installation_(vCentre)#Create_DSN|DSN to vCentre Database]]&lt;br /&gt;
...for small (less than 5 ESX&amp;#039;s and 50 VM&amp;#039;s, and normally all test) installs you can skip this, and let the vCentre installer use SQL 2008 Express&lt;br /&gt;
# Select &amp;#039;&amp;#039;VMware vCentre Server&amp;#039;&amp;#039; from the installer menu, and click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Click &amp;#039;&amp;#039;&amp;#039;Allow&amp;#039;&amp;#039;&amp;#039; or &amp;#039;&amp;#039;&amp;#039;Continue&amp;#039;&amp;#039;&amp;#039; if you get a &amp;#039;&amp;#039;User Account Control&amp;#039;&amp;#039; warning&lt;br /&gt;
# Change the installer language if required, then click &amp;#039;&amp;#039;&amp;#039;OK&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039; at both the &amp;#039;&amp;#039;VMware vCentre Server&amp;#039;&amp;#039; install start, and &amp;#039;&amp;#039;End User Patent Agreement&amp;#039;&amp;#039; screens&lt;br /&gt;
# Accept [[Acronyms#E|EULA]], and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Enter vCentre license key (if you have one), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Select &amp;#039;&amp;#039;Use an existing supported database&amp;#039;&amp;#039;, and select the DSN for your vCentre database, and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* You can yse &amp;#039;&amp;#039;Install a Microsoft SQL 2008 Express instance...&amp;#039;&amp;#039; for small scale or non-production deployments only&lt;br /&gt;
#* Select an existing DSN (to set-up a new DSN, see [[#Create DSN|Create DSN]])&lt;br /&gt;
# Enter the password for &amp;#039;&amp;#039;vpxuser&amp;#039;&amp;#039; (created during database creation), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* You may get a pop-up regarding using both TCP/IP and named pipes for remote conmections&lt;br /&gt;
#*# Start the &amp;#039;&amp;#039;SQL Server Configuration Manager&amp;#039;&amp;#039;&lt;br /&gt;
#*# Go to &amp;#039;&amp;#039;SQL Server Network Configuration &amp;gt; Protocols for MSSQLSERVER&amp;#039;&amp;#039;&lt;br /&gt;
#*# Set &amp;#039;&amp;#039;Named Pipes&amp;#039;&amp;#039; to &amp;#039;&amp;#039;&amp;#039;Enabled&amp;#039;&amp;#039;&amp;#039; (you&amp;#039;ll need to restart SQL to apply)&lt;br /&gt;
# Leave the vCentre Server Service to use the SYSTEM account&lt;br /&gt;
#* If you need to change this, do not use a domain account, in the event of a distaster you want to be able to run the service without dependance on outside infrastructure that could be down or unreachable&lt;br /&gt;
# Select the appropriate &amp;#039;&amp;#039;Linked Mode&amp;#039;&amp;#039; (this proc assumes Standalone, use this unless you know different), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Accept the default TCP ports (its recommended that you don&amp;#039;t share the server with other services which, for example, might necessitate changing the vCentre ports), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
# Select the appropriate &amp;#039;&amp;#039;Inventory Size&amp;#039;&amp;#039; for your environment, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* If you expect your infrastructure to grow, and you have sufficient memory available, then use what you expect your final inventory size to be&lt;br /&gt;
# Enter the password for the SSO admin account (created in SSO install), and then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* If you installed SSO on a different server, you&amp;#039;ll also need to update the &amp;#039;&amp;#039;Lookup service URL&amp;#039;&amp;#039;&lt;br /&gt;
# Set a group or user account that should be used by SSO to allow admin access to vCentre, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* I&amp;#039;d recommend creating a local group on the server called something like&amp;#039;&amp;#039;&amp;#039;VC-Admins&amp;#039;&amp;#039;&amp;#039;, and add into that any local or domain users or groups that should have access&lt;br /&gt;
#* Don&amp;#039;t use the default &amp;#039;&amp;#039;Administrators&amp;#039;&amp;#039; local group if there are people such as domain admins that should not have admin access over your virtual estate&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039; to accept the default &amp;#039;&amp;#039;Inventory Service URL&amp;#039;&amp;#039;&lt;br /&gt;
#* If you installed ytour &amp;#039;&amp;#039;Inventory Service&amp;#039;&amp;#039; on a different server, you&amp;#039;ll also need to update the &amp;#039;&amp;#039;vCenter Inventory Service URL&amp;#039;&amp;#039; &lt;br /&gt;
# If required, change the &amp;#039;&amp;#039;Destination Folder&amp;#039;&amp;#039;, then click &amp;#039;&amp;#039;&amp;#039;Next&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
#* Its common to install to a seperate disk, eg &amp;lt;code&amp;gt;D:\VMware\Infrastructure&amp;lt;/code&amp;gt;&lt;br /&gt;
# Click &amp;#039;&amp;#039;&amp;#039;Install&amp;#039;&amp;#039;&amp;#039; to complete the installation&lt;br /&gt;
&lt;br /&gt;
[[Category:VMware]]&lt;br /&gt;
[[Category:vCentre]]&lt;br /&gt;
[[Category:MS SQL]]&lt;/div&gt;</summary>
		<author><name>Sstrutt</name></author>
	</entry>
</feed>