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.

Thursday, September 17, 2009

Cannot connect to SQL Server 2005 on Vista

If you are reading this article it means you already ran into the problem of connection (login) issue with SQL Server 2005 on Windows Vista. Let me explain the scenario:

I opened up SQL Server Management Studio and tried to log in using Windows Authentication but SQL Server came up with login failed error (Login Failed for user blabla, Error: 18456)
I tried using SQL Server Authentication and typed 'sa' (without quotes obviously) as username and the password. To my surprise i faced another error that the user sa is not a trusted user. Now i was wondering how to log in and change the settings or reset the passwords. The "sa" account was disabled and windows authentication was not working as required. I thought maybe due to my changing the password for my user account it happend, so I changed my windows account password back to the previous one however the attempt to connect to SQL Server was again failed. After a little thought I came to the conclusion that Windows Vista User Account Control is the culprit here.
So what i did was as follows:

1. Right click the shortcut or executable for SQL Server Management Studio and Select Run as Adminsitrator
2. Select the server name for SQL Server installed on the machine
3. Select Windows Authentication and click Connect. Vola! it worked this time.
4. In Object Manager Click Security -> Logins Right click Logins and select New Login
5. Search and add your windows account. e.g: ComputerName\TestUser
6. Select Server Roles on the Left and check sysadmin box on the right at the very bottom of defined roles
7. Click OK. That's it, you are done now.
8. Also remember to enable "sa" account and give it a strong password if you are using Mixed Mode Authentication.

I hope it helps.