{"id":1118,"date":"2013-02-12T20:24:08","date_gmt":"2013-02-12T20:24:08","guid":{"rendered":"https:\/\/pipe2text.com\/?page_id=1118"},"modified":"2013-03-20T14:27:08","modified_gmt":"2013-03-20T14:27:08","slug":"after-moving-virtualcenter-database-update-manager-displays-an-error","status":"publish","type":"page","link":"https:\/\/pipe2text.com\/?page_id=1118","title":{"rendered":"After moving VirtualCenter database update manager  displays an error"},"content":{"rendered":"<p><span>After moving <span>VirtualCenter<\/span> 5.1\u00a0database to a different SQL server the Update Manager component displays an error stating the following:<\/span><\/p>\n<p><em><strong><span>There was an error connecting to <span>vmware<\/span> <span>vsphere<\/span> update manager {vcenterserver1:443}<\/span>\u00a0<\/strong><\/em><\/p>\n<p><em><strong>Database temporarily unavailable or has network issues<\/strong><\/em><\/p>\n<p><span>Opening up ODBC <span>thru<\/span> administrative tools -&gt; data sources does not<\/span><span>\u00a0show a System DSN for &#8220;UMDB&#8221;. It will only display the VCDB connection\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC21-300x2452.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1153\" title=\"ODBC21-300x245\" src=\"https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC21-300x2452.png\" alt=\"\" width=\"300\" height=\"245\" \/><\/a><\/p>\n<p>To display the &#8220;UMDB&#8221; connection run the following command in start -&gt; run<\/p>\n<p><em><strong>C:\\Windows\\SysWOW64\\odbcad32.exe<\/strong><\/em><\/p>\n<p>This will display the 32 bit ODBC connection and from here you will be able to repoint the Update Manager database to the proper SQL server<\/p>\n<p><a href=\"https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-1129\" title=\"ODBC1\" src=\"https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC11-300x244.png\" alt=\"\" width=\"300\" height=\"244\" srcset=\"https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC11-300x244.png 300w, https:\/\/pipe2text.com\/wp-content\/uploads\/2013\/02\/ODBC11.png 457w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After moving VirtualCenter 5.1\u00a0database to a different SQL server the Update Manager component displays an error stating the following: There was an error connecting to vmware vsphere update manager {vcenterserver1:443}\u00a0 Database temporarily unavailable or has network issues Opening up ODBC &hellip; <a href=\"https:\/\/pipe2text.com\/?page_id=1118\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"class_list":["post-1118","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/pipe2text.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1118"}],"version-history":[{"count":12,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1118\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1118\/revisions\/1124"}],"wp:attachment":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}