Wednesday, October 7, 2009

Edition Change Check (Warning)

Edition Change Check (Warning)

This is the most common warning message reported on Windows Vista and Windows 7 related to SQL Server installation. There are various reasons for this message but the most common issue is to run the setup from the same DVD from which you first installed SQL Server 2005. I have faced this issue several times on different machines running Windows Vista and Windows 7 Evaluation build 7100. My findings are as follows:

Whenever you run SQL Server setup.exe on a Vista or Windows 7 machine the system configuration checker checks the system it issues this warning (Edition Change Check). No matter what Edition of SQL Server is installed on the system perviously. The prime reason behind this is that you have installed and applied service packs on SQL Server instance and its components. The installer you are running first gives you the compatibility warning and once you ignore it and run the setup, it will give you Edition change check warning. There are two approaches to this:

1. Ignore the message and continue
2. Run the SQL Server 2005 Setup from a command line and provide the upgarede option as follows:

Setup.exe SKUUPGRADE = 1

This will run the setup with upgrade option and the Edition Check warning disappears. See below:
























Hope it helps.

Unhandled Exception, Error while switching panels, SSRS, SQL Server 2005 Reporting Services

I tried to add reporting services today to my existing SQL Server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked Server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found that I had installed SQL Server 2005 Service Pack 3 (SP3). However reporting service has just been installed and the SP3 wasn’t applied to it. Here is how I resolved:


Problem:

1. Error I faced upon first run of SSRS Configuration Manager





 
 
 
 
 
 
 
 
 
 
 
 


 
2. Second Error I faced when I clicked on the panel on left side




 
 
 
 
 
 
 
 
 
 
 
 
 


 
Resolution:
1. Download the relevant service pack you have already applied to SQL Server or most probably you already have it as you have installed it before.

2. In my case I had applied SP3 before I installed SSRS. You can download it here:

3. http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

4. You can download the versions for x86, x64 or IA64 versions depending upon you hardware and OS platform. I download this one SQLServer2005SP3-KB955706-x86-ENU

5. Once downloaded double click it and you will see the following screen:




 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


6. By default the checkboxes will be selected for whatever component the service pack wasn’t applied and in our case its Reporting Services
7. Hit Next




 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

8. Once the service pack is applied you would see the above screen hit Next again then the following screen























9. The last screen will be the following. You don’t need to apply windows vista provision tool at this stage since you must have already added your windows user to sysadmin group using this tool when you first installed SQL Server2005 on Vista or Windows 7. If not then do that too























Hope it Helps.

IIS Feature Requirements (Warning) Windows 7 and Vista

I had installed SQL Server 2005 on Windows 7 and applied SP3. Everything was working fine till today when i decided to install Reporting Services (SSRS). I installed IIS from Control Panel -> Programs and Features -> Turn Windows Features On or Off. Then i ran SQL Server steup and got to the point of System Configuration Checker. It gave me the IIS Feature Requirements (Warning) and when i tried to continue i saw Reporting Services Cehckbox disabled. Upon searching through the internet i found a very useful link which was the only one that fixed my problem. Thanks to Martin Poon Microsoft MVP whose blog helped me. The link to his blog is:
http://msmvps.com/blogs/martinpoon/default.aspx

and the link to his article is:
http://msmvps.com/blogs/martinpoon/archive/2006/12/08/installation-of-sql-server-2005-in-windows-vista-warning-message-on-iis-feature-requirement-during-system-configuration-check.aspx

I am rewriting this article for my own reference and for others who need help in this scenario and becauase the background and text color of Martin's blog for this article made it very difficult to read so i had to select all the text and then read it properly.

When you run the SQL Server install the system configuration checker displays the following message:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

Steps to Resolve the Issue:

Applies to Windows 7 and Vista:
  1. Start
    1. Control Panel
    2. Programs and Features
    3. Turn Windows features on or off
    4. Enable
  2. Enable various features of IIS
    1. Web management tools
    2. IIS 6 Management Compatibility
      1. IIS 6 WMI Compatibility
        1. IIS Metabase and IIS 6 configuration compatibility
      2. World Wide Web Services
        1. Application Development Features
          1. ASP.NET
          2. ISAPI Extensions
          3. ISAPI Filters
        2. Common Http Features
          1. Default Document
          2. Directory Browsing
          3. HTTP Redirection
          4. Static Content
        3. Security
          1. Windows Authentication
  3. Now run the SQL Server 2005 Setup again

Hope this would be helpful.
There was an error in this gadget