My Dynamic World

SQL Upgrade Error - Access to License Denied Ahh a wonderful time to experience an error, when you are upgrading SQL, during a limited window for downtime.  Sop much for the weekend plans eh? No worries, this one is easy.  In my case I received the following when downgrading an edition for a reporting Server that houses several instances.  After the first one processed, I received this error: If I browse to that path, we notice the file is set to read only. Easy enough, lets un-check read only and try again.  Success!  I had to do this for each instance install.  So if you have multiple instances be prepared to set the file to read/write each time.

While trying to determine and configure some settings in SQL 2012 I ran across this error:   Seems this can occur, from Microsoft:  http://support.microsoft.com/kb/956013 Open a Administrative command prompt, and run this to fix for SQL 2012:  mofcomp "%programfiles(x86)%\Microsoft SQL Server\ 110 \Shared\sqlmgmproviderxpsp2up.mof" Then restart the WMI service.