{"id":7768,"date":"2013-10-29T07:01:29","date_gmt":"2013-10-29T06:01:29","guid":{"rendered":"http:\/\/nolabnoparty.com\/?p=7768"},"modified":"2023-07-16T11:22:23","modified_gmt":"2023-07-16T09:22:23","slug":"vcenter-create-update-manager-database-dsn","status":"publish","type":"post","link":"https:\/\/nolabnoparty.com\/en\/vcenter-create-update-manager-database-dsn\/","title":{"rendered":"vCenter 5.5: create Update Manager database and DSN"},"content":{"rendered":"<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 10px auto 5px; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn01\" alt=\"vsphere55updmgrdsn01\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn01.jpg\" width=\"602\" height=\"202\" border=\"0\" \/><\/p>\n<p>If the Update Manager database is installed on a dedicated SQL server, the Update Manager database and DSN must be set to properly <strong>link the DB to vCenter<\/strong>.<\/p>\n<p>To perform this configuration <strong>a working MS-SQL server<\/strong>\u00a0is required.<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<h2>Installation guide<\/h2>\n<ul>\n<li><a title=\"vSphere 5.5: install guide introduction\" href=\"https:\/\/nolabnoparty.com\/en\/vsphere-5-5-install-guide-introduction\/\">Part 1 - Install guide introduction<\/a><\/li>\n<li><a title=\"vSphere 5.5: installing ESXi\" href=\"https:\/\/nolabnoparty.com\/en\/vsphere-5-5-installing-esxi\/\">Part 2 - Install ESXi 5.5<\/a><\/li>\n<li><a title=\"vSphere 5.5: installing vCenter Single Sign-On\" href=\"https:\/\/nolabnoparty.com\/en\/vsphere-55-installing-vcenter-single-signon\/\">Part 3 - Install vCenter Single Sign-On<\/a><\/li>\n<li><a title=\"vCenter 5.5: installing vSphere Web Client\" href=\"https:\/\/nolabnoparty.com\/en\/vcenter-55-installing-vsphere-web-client\/\">Part 4 - Install vSphere Web Client<\/a><\/li>\n<li><a title=\"vCenter 5.5: installing vCenter Inventory Service\" href=\"https:\/\/nolabnoparty.com\/en\/vcenter-5-5-installing-vcenter-inventory-service\/\">Part 5 - Install Inventory Service<\/a><\/li>\n<li><a title=\"vCenter 5.5: create vCenter database and DSN\" href=\"https:\/\/nolabnoparty.com\/en\/vmware-vcenter-5-5-create-vcenter-database-dsn\/\">Part 6 - Create vCenter database and DSN<\/a><\/li>\n<li><a title=\"vCenter 5.5: installing vCenter Server\" href=\"https:\/\/nolabnoparty.com\/en\/vcenter-5-5-installing-vcenter-server\/\">Part 7 - Install vCenter Server<\/a><\/li>\n<li><strong><span style=\"color: #ff0000;\">Part 8 - Create Update Manager database and DSN<\/span><\/strong><\/li>\n<li><a title=\"vCenter 5.5: installing vSphere Update Manager\" href=\"https:\/\/nolabnoparty.com\/en\/vcenter-5-5-installing-vsphere-update-manager\/\">Part 9 - Install Update Manager<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>Part 8 - Create Update Manager database and DSN<\/h2>\n<p>From <strong>MS-SQL Server<\/strong>, open the <strong>SQL Studio Management<\/strong> tool and access the system. Right click <strong>Databases<\/strong> item and select <strong>New Database<\/strong> option.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn02\" alt=\"vsphere55updmgrdsn02\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn02.jpg\" width=\"355\" height=\"318\" border=\"0\" \/><\/p>\n<p>Type a <strong>Database name<\/strong> (VIM_UPD) and assign the <strong>Owner<\/strong>. The owner should be <strong>same account<\/strong> used during vCenter setup. Click <strong>OK<\/strong> to confirm.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn03\" alt=\"vsphere55updmgrdsn03\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn03.jpg\" width=\"600\" height=\"539\" border=\"0\" \/><\/p>\n<p>The <strong>new database<\/strong> used by Update Manager is then created. Exit SQL Server Studio Management.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn04\" alt=\"vsphere55updmgrdsn04\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn04.jpg\" width=\"354\" height=\"351\" border=\"0\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4>Setup DSN<\/h4>\n<p>Because we have already installed the SQL Server 2008 R2 Native Client during <a href=\"http:\/\/ff\" target=\"_blank\" rel=\"noopener\">vCenter setup<\/a>, we just need to define <strong>DSN for Update Manager<\/strong>.<\/p>\n<p>While Update Manager requires <strong>32-bits DSN<\/strong> for its database, vCenter is actually running on 64-bits architecture. To properly setup the DSN we need to access the 32-bits version of <strong>ODBC Data Source Administrator<\/strong>: \u00a0in Windows run the file <strong>%windir%\/syswow64\/odbcad.exe<\/strong>.<\/p>\n<p>From <strong>Create New Data Source<\/strong> window, select <strong>SQL Server Native Client 10.0<\/strong> driver and click <strong>Next<\/strong> to start the configuration.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn05\" alt=\"vsphere55updmgrdsn05\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn05.jpg\" width=\"501\" height=\"481\" border=\"0\" \/><\/p>\n<p>Type a <strong>Name<\/strong> and a <strong>Description<\/strong> for your data source. Click the right arrow in the <strong>Server<\/strong> field and select the <strong>SQL instance<\/strong> you want to connect to. Click <strong>Next<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn06\" alt=\"vsphere55updmgrdsn06\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn06.jpg\" width=\"510\" height=\"388\" border=\"0\" \/><\/p>\n<p>Leave default settings then click <strong>Next<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn07\" alt=\"vsphere55updmgrdsn07\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn07.jpg\" width=\"510\" height=\"388\" border=\"0\" \/><\/p>\n<p>Check the\u00a0<strong>Change the default database to<\/strong> field and select the Update Manager database (VIM_UPD)\u00a0previously created. Click <strong>Next<\/strong> to continue.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn08\" alt=\"vsphere55updmgrdsn08\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn08.jpg\" width=\"510\" height=\"388\" border=\"0\" \/><\/p>\n<p>Leave default settings then click <strong>Finish<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn09\" alt=\"vsphere55updmgrdsn09\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn09.jpg\" width=\"510\" height=\"388\" border=\"0\" \/><\/p>\n<p>Test the connection with\u00a0<strong>Test Data Source<\/strong> button.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn10\" alt=\"vsphere55updmgrdsn10\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn10.jpg\" width=\"368\" height=\"379\" border=\"0\" \/><\/p>\n<p>If you get the message:<\/p>\n<blockquote><p>TESTS COMPLETED SUCCESSFULLY<\/p><\/blockquote>\n<p>your system is properly configured. Click <strong>OK<\/strong> to save the DSN parameters.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"margin: 0px auto; padding-left: 0px; padding-right: 0px; float: none; padding-top: 0px; border-width: 0px;\" title=\"vsphere55updmgrdsn11\" alt=\"vsphere55updmgrdsn11\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2013\/10\/vsphere55updmgrdsn11.jpg\" width=\"368\" height=\"379\" border=\"0\" \/><\/p>\n<p>The database and DSN are now created. Last step to complete the vCenter Server setup is the\u00a0<strong>Update Manager <\/strong>installation.<\/p>\n<p>Next: <a title=\"vCenter 5.5: installing vSphere Update Manager\" href=\"https:\/\/nolabnoparty.com\/en\/vcenter-5-5-installing-vsphere-update-manager\/\">Part 9 - Install Update Manager<\/a><\/p>\n<p><img decoding=\"async\" alt=\"firma\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/images\/firma.jpg\" title=\"\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If the Update Manager database is installed on a dedicated SQL server, the Update Manager database and DSN must be set to properly link the DB to vCenter. To perform this configuration a working MS-SQL server\u00a0is required.<\/p>\n","protected":false},"author":3,"featured_media":7757,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"linkedin_93tdZWzMZc_93tdZWzMZc":"","facebook_2879994398731222_17841400390232720":"","twitter_113568041_113568041":"","mastodon_115463926174894442_115463926174894442":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[903,2701],"tags":[695,718,719,583],"class_list":["post-7768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware-en","category-vsphere-en","tag-database-en","tag-sql-en","tag-update-manager-en","tag-vcenter-en","has_thumb"],"_links":{"self":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/7768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/comments?post=7768"}],"version-history":[{"count":0,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/7768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media\/7757"}],"wp:attachment":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media?parent=7768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/categories?post=7768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/tags?post=7768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}