{"id":1630,"date":"2011-08-24T08:58:24","date_gmt":"2011-08-24T13:58:24","guid":{"rendered":"http:\/\/www.jasemccarty.com\/blog\/?p=1630"},"modified":"2011-12-30T09:28:57","modified_gmt":"2011-12-30T15:28:57","slug":"vcenter-sql-express-dependency-no-more-in-5-0","status":"publish","type":"post","link":"https:\/\/www.jasemccarty.com\/blog\/vcenter-sql-express-dependency-no-more-in-5-0\/","title":{"rendered":"vCenter SQL Express dependency &#8211; no more in 5.0"},"content":{"rendered":"<p>It is not uncommon for small environments to leverage the included SQL Server Express database that is included with VMware vCenter Server.<\/p>\n<p>When a vCenter Server is installed in this manner, many administrators have noticed that when the vCenter Server is rebooted, from time to time, the service isn&#8217;t available upon restart.\u00a0 This is because the vCenter Service requires the SQL Server to be online before it can start.\u00a0 This issue can be resolved by making the vCenter Service dependent on the SQL Server Express service.<\/p>\n<p>There are many blog posts on how to make this change for vCenter 2.x and vCenter 4.x:<\/p>\n<ul>\n<li>Duncan Epping: <strong><a title=\"vCenter and SQL service dependencies\" href=\"http:\/\/www.yellow-bricks.com\/2009\/02\/12\/vcenter-and-sql-service-dependencies\/\"> vCenter and SQL service dependencies<\/a><\/strong><\/li>\n<li>VMware KB: <strong><a title=\" VMware VirtualCenter Server service does not start automatically after reboot\" href=\"http:\/\/kb.vmware.com\/kb\/1007669\" target=\"_blank\">VMware VirtualCenter Server service does not start automatically after reboot<\/a><\/strong><\/li>\n<li>Vladan Seget: <strong><a title=\"vCenter Server Service does not start automatically\" href=\"http:\/\/www.vladan.fr\/vcenter-server-service-does-not-start-automaticaly\/\" target=\"_blank\">vCenter Server Service does not start automatically<\/a><\/strong><\/li>\n<li>Nick Weaver: <strong><a title=\"More PS Fun : Fix vCenter Startup w\/ PowerShell\" href=\"http:\/\/nickapedia.com\/2011\/03\/02\/more-ps-fun-fix-vcenter-startup-w-powershell\/\" target=\"_blank\">More PS Fun : Fix vCenter Startup w\/ PowerShell<\/a><\/strong><\/li>\n<\/ul>\n<p>With vCenter Server 5.0, VMware has corrected the issue.<\/p>\n<p><!--more-->Upon installing vCenter Server 5.0 on a Windows 2008 R2 server (VM) I noticed that the dependency was taken care of.<\/p>\n<p><a href=\"http:\/\/www.jasemccarty.com\/blog\/wp-content\/uploads\/2011\/08\/SQLDependentvC.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1633\" title=\"SQL Server Dependency\" src=\"http:\/\/www.jasemccarty.com\/blog\/wp-content\/uploads\/2011\/08\/SQLDependentvC.png\" alt=\"\" width=\"413\" height=\"466\" \/><\/a><\/p>\n<p>I know that many won&#8217;t go the route of installing the included database, but for those that do, it is a welcome addition.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is not uncommon for small environments to leverage the included SQL Server Express database that is included with VMware vCenter Server. When a vCenter &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[85,94,112],"class_list":["post-1630","post","type-post","status-publish","format-standard","hentry","category-virtualization","tag-sqlexpress","tag-vcenter","tag-vsphere5"],"_links":{"self":[{"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/posts\/1630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/comments?post=1630"}],"version-history":[{"count":1,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/posts\/1630\/revisions"}],"predecessor-version":[{"id":1977,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/posts\/1630\/revisions\/1977"}],"wp:attachment":[{"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/media?parent=1630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/categories?post=1630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jasemccarty.com\/blog\/wp-json\/wp\/v2\/tags?post=1630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}