SQL Reporting is grayed out and won't let me install it. (NETIQKB73098)

  • 7773098
  • 15-Jul-2011
  • 15-Jul-2011

Environment

Security Manager 6.0.X

Security Manager 6.5.X

SQL 2005

SQL 2008

Reporting install

Windows 2008

Situation

SQL Reporting is grayed out and won't let me install it.
Trying to install SQL Reporting, hoever the option will not allow it to be selected.

Resolution

      Configure a server role and enable ASP.NET and IIS. To do this, follow these steps:

  1. Click Start, and then click Server Manager.
  2. In Server Manager, right-click Manage Roles, and then click Add roles. The Add Roles Wizard starts.
  3. In the Add Roles Wizard, click Select Server Roles.
  4. On the Select Server Roles page, click to select the Web Server (IIS) check box, and then click Next.

    Note Because of role dependency, the File Server check box is automatically selected when you click to select the Web Server (IIS) check box.
  5. On the Role Services page, expand Common HTTP Features, and then click to select the following check boxes:
    • Static Content
    • Default Document
    • Directory Browsing
    • HTTP Errors
    • HTTP Redirection
  6. Expand Application Development, and then click to select the ASP.NET check box.
    Note If you are prompted to add required role services, click OK.
  7. Expand Security, and then click to select the Windows Authentication check box.
  8. Expand Management Tools, expand IIS 6 Management Capability, and then click to select the following check boxes:
    •      IIS Metabase Compatibility
    •      IIS 6 WMI Compatibility
    •      IIS 6 Scripting Tools
    •      IIS 6 Management Console
  9. Click Next, and then click Install.
  10. Note If you do not enable all these features, the Reporting Services option does not appear in the Feature Selection dialog box of the SQL Server Setup program.
  11. Verify that the World Wide Web Publishing service is started. If the World Wide Web Publishing service is not started, configure the service to start automatically. To do this, follow these steps:
  12. In Control Panel, click System and Maintenance.
  13. Click Administrative Tools.
  14. Double-click Services.
  15. In the User Account Control dialog box, click Continue.
  16. Right-click World Wide Web Publishing Service, and then click Properties.
  17. In the World Wide Web Publishing Service Properties dialog box, select Automatic in the Startup type list.
  18. Click Apply, click Start, and then click OK.

Note If you are installting 32 bit Reporting services in a 64 bit environment, refer to the following Knowledge base article: For more information about how to install a 32-bit version of the reporting services on a 64-bit operating system, click the following article number to view the article in the Microsoft Knowledge Base:

934162 (http://support.microsoft.com/kb/934162/ ) How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows

Cause

There are windows components not installed.

Additional Information

Formerly known as NETIQKB73098