{"id":3557,"date":"2018-08-13T00:27:05","date_gmt":"2018-08-13T00:27:05","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=3557"},"modified":"2018-08-13T00:46:55","modified_gmt":"2018-08-13T00:46:55","slug":"unable-to-upgrade-the-localdb-sql-express-database-running-during-aadconnect-upgrade","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/unable-to-upgrade-the-localdb-sql-express-database-running-during-aadconnect-upgrade","title":{"rendered":"Unable to upgrade the LocalDB Sql Express database Running during AADconnect upgrade"},"content":{"rendered":"\n

I was recently trying to Upgrade the AADconnect server to stop the high 100% CPU issues<\/p>\n\n\n\n

After running the MSI .<\/g> then running\u00a0AzureADConnect.exe ,<\/g> the upgrade came up with the error<\/p>\n\n\n\n

Unable to upgrade the LocalDB Sql Express database Running<\/strong><\/p>\n\n\n\n

I went to the event log and found the error :<\/p>\n\n\n\n

Error installing msi package ‘SqlLocalDB.msi’. Full log is available at ‘C:\\ProgramData\\AADConnect\\SqlLocalDB_Upgrade-20180813-094321.log’.<\/p>\n\n\n\n

I checked through the Log and there seemed to be lots of 1603 errors<\/p>\n\n\n\n

I ran the SQL Setup ( C:\\Program Files\\Microsoft Azure Active Directory Connect\\SetupFiles\\SqlLocalDB.msi ) manually and it asked if I wanted to upgrade my LocalDB from 2008 to 2012 which I said yes to\u00a0<\/div><\/p>\n\n\n\n

The installer then came up with the error SQL Server 2012 Express LocalDB<\/p>\n\n\n\n

Could not open key: UNKNOWN\\Components\\. Verify that you have sufficient access to that key, or contact your support personnel.<\/strong><\/p>\n\n\n\n

<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

I ran through the workaround 1 from this guide<\/p>\n\n\n\n

https:\/\/blogs.msdn.microsoft.com\/sqlserverfaq\/2010\/03\/30\/sql-server-2008-setup-fails-to-install-with-error-1402\/<\/a><\/p>\n\n\n\n

And then the\u00a0SqlLocalDB.msi finished successfully , I was then able to run through the\u00a0AzureADConnect.exe upgrade<\/p>\n\n\n\n

<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

I was recently trying to Upgrade the AADconnect server to stop the high 100% CPU issues After running the MSI . then running\u00a0AzureADConnect.exe , the upgrade came […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2621,2619,2198,2617,2622,2618],"class_list":["post-3557","post","type-post","status-publish","format-standard","hentry","category-research","tag-2621","tag-2619","tag-aadconnect","tag-localdb","tag-sqllocaldb-msi","tag-unable-to-upgrade"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=3557"}],"version-history":[{"count":3,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3557\/revisions"}],"predecessor-version":[{"id":3561,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3557\/revisions\/3561"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=3557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=3557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=3557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}