<div dir="ltr" style="text-align: left;"><span style="-webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21.875px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">In this part we will create the DSNs.</span><span style="-webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21.875px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">The three vCenter components which are using databases are Single Sign On, vCenter Server and VMware Update Manager. All those components points to the databases we I have installed on our SQL server 2012 which we have created in this artical <a href="http://bzia.blogspot.co.uk/2014/12/installation-of-esxi-server-55-and-its_31.html">http://bzia.blogspot.co.uk/2014/12/installation-of-esxi-server-55-and-its_31.html</a>.</span><br /><span style="-webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21.875px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><br /></span></p>
<h3 style="background-color: white; color: black; font-family: Verdana,sans-serif; font-size: 24px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 1.25; margin: 0px 0px 10px; padding: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">DSN Creation</h3>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Next step we need to do is to create DSNs. We will use the 64 bit version of DSN and the 32 bit version is still needed for VUM and SRM.</div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">VMware vSphere 5.1<span style="position: absolute;"></span><span style="position: absolute;"></span><span> ;</span>Single Sign-On DB (needs 64 bit ODBC)<span> ;</span></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><span>VMware vSphere vCenter server</span><span style="position: absolute;"></span><span style="position: absolute;"></span><span> ;</span>DB ;(needs 64 bit ODBC)</div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">VMware Update Manager DB ;(needs 32 bit ODBC)</div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Locate and Open following to setup ODBC data source </div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"> ;<span style="-webkit-text-stroke-width: 0px; background-color: whitesmoke; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 12px; font-style: italic; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18.75px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">c:WindowsSysWOW64odbcad64.exe</span></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><span style="-webkit-text-stroke-width: 0px; background-color: whitesmoke; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 12px; font-style: italic; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18.75px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">c:WindowsSysWOW64odbcad32.exe</span></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Create all three under System DNS</div>
<div style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-nJLqfmSXlOs/VKVbxspldeI/AAAAAAAAA5g/OoMml-0CRWI/s1600/DNS.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-nJLqfmSXlOs/VKVbxspldeI/AAAAAAAAA5g/OoMml-0CRWI/s1600/DNS.JPG" height="283" width="400" /></a></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin: 0px 0px 15px; orphans: auto; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><span></span><span></span><span style="-webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: Verdana, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21.875px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Once the three ODBC connections done, you should see them all in the System DSN tab, and you can start installing the different vCenter components.</span></div>
</div>

The Cyber Security, Compliance & Cloud
Cyber Security | Digital Transformation | Cloud Computing
