You are currently offline, waiting for your internet to reconnect

SQL Server Compact 3.5 Service Pack 1 Server Tools are not installed in WOW mode when you run IIS 7.0 on a 64-bit Windows Server 2008-based computer or on a 64-bit Windows Vista-based computer

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SYMPTOMS
Consider the following scenario:
  • You are running Internet Information Services 7.0 (IIS 7.0) on a computer that is running a 64-bit version of Windows Server 2008 or a 64-bit version of Windows Vista.
  • On this computer, you try to install Microsoft SQL Server Compact 3.5 Service Pack 1 (SP1) Server Tools in Windows on Windows (WOW) mode.
In this scenario, the installation is not completed successfully.
CAUSE
This problem occurs because the Setup program does not locate IIS 7.0.
WORKAROUND
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To work around this problem, follow these steps:
  1. Install the Internet Information Services 6.0 (IIS 6.0) backward compatibility components. To do this, use one of the following procedures:
    • In Windows Server 2008, follow these steps:
      1. Click Start, click Administrative Tools, and then click Server Manager.
      2. In the left navigation pane, expand Roles, right-click Web Server (IIS), and then click Add Role Services.
      3. In the Select Role Services pane, scroll down to IIS 6 Management Compatibility.
      4. Click to select the following check boxes:
        • IIS 6 Metabase Compatibility
        • IIS 6 Management Console
      5. In the Select Role Services pane, click Next, and then click Install in the Confirm Installations Selections pane.
      6. Click Close to exit the Add Role Services Wizard.
    • In Windows Vista, follow these steps:
      1. Click Start, click Control Panel, click Programs and Features, and then click Turn Windows features on or off.
      2. Click Internet Information Services.
      3. Click Web Management Tools.
      4. Click IIS 6.0 Management Compatibility.
      5. Click to select the following check boxes:
        • IIS 6 Metabase
        • IIS 6 configuration compatibility
        • IIS 6 Management Console
      6. Click OK.
  2. Start Registry Editor.
  3. Change the MajorVersion setting to 6 under the following registry subkey:
    HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\InetStp
  4. On the File menu, click Exit to exit Registry Editor.
  5. Install the SQL Server Compact 3.5 SP1 Server Tools.
  6. After the server tools installation has completed successfully, change the MajorVersion setting to 7 in the registry. To do this, follow these steps:
    1. Start Registry Editor.
    2. Change the MajorVersion setting to 7 under the following registry subkey:
      HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\InetStp
    3. On the File menu, click Exit to exit Registry Editor.
sqlserver2008 sqlserver2k8 sqlsvr2008 sqlsvr2k8
Properties

Article ID: 955966 - Last Review: 08/06/2008 19:33:06 - Revision: 1.0

Microsoft SQL Server Compact 3.5

  • kbsetup kbexpertiseinter kbtshoot kbprb KB955966
Feedback
varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("