{"id":4876,"date":"2020-11-09T01:23:21","date_gmt":"2020-11-09T01:23:21","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=4876"},"modified":"2020-11-09T01:23:21","modified_gmt":"2020-11-09T01:23:21","slug":"cannot-change-azure-sql-virtual-machines-from-express-to-developer","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/cannot-change-azure-sql-virtual-machines-from-express-to-developer","title":{"rendered":"Cannot change Azure SQL Virtual Machines from Express to Developer"},"content":{"rendered":"

I got deployment failed when trying to change a SQL servers License from Express to Developer.<\/p>

I checked the Server and it had developer license installed on SQL<\/p>

\"\"<\/p>

Looking at the JSON<\/p>

{<\/div>
\u00a0\u00a0\u00a0\u00a0“status”:\u00a0“Failed”,<\/div>
\u00a0\u00a0\u00a0\u00a0“error”:\u00a0{<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“code”:\u00a0“ResourceDeploymentFailure”,<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“message”:\u00a0“The\u00a0resource\u00a0operation\u00a0completed\u00a0with\u00a0terminal\u00a0provisioning\u00a0state\u00a0‘Failed’.”,<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“details”:\u00a0[<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“code”:\u00a0“MismatchSqlVmSku”,<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“message”:\u00a0“The\u00a0SQL\u00a0sku\u00a0provided\u00a0is\u00a0‘Developer’\u00a0which\u00a0does\u00a0not\u00a0match\u00a0the\u00a0sku\u00a0installed\u00a0in\u00a0the\u00a0virtual\u00a0machine\u00a0‘Express’.\u00a0Make\u00a0sure\u00a0to\u00a0provide\u00a0the\u00a0correct\u00a0sku\u00a0type.”<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/div>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]<\/div>
\u00a0\u00a0\u00a0\u00a0}<\/div>
}<\/div>
\u00a0<\/div>
Its because there was an old version of SQL express installed , removing this fixed the issue<\/div>","protected":false},"excerpt":{"rendered":"

I got deployment failed when trying to change a SQL servers License from Express to Developer.I checked the Server and it had developer license installed on SQLLooking […]<\/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":[1464,3380,822,591,3379],"class_list":["post-4876","post","type-post","status-publish","format-standard","hentry","category-research","tag-azure","tag-deployment-failure","tag-license","tag-sql","tag-sql-virtual-machines"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t