Analysis Center Data Extension for SQL Reporting Services is absent. (NETIQKB44532)

  • 7744532
  • 02-Feb-2007
  • 25-May-2011

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Reporting Services (SRS)

Situation

Analysis Center Data Extension for SQL Reporting Services is absent.
Error: 'Cannot open ReportServer service'
Analysis Center Enterprise view displays red 'X' on Report Server.

Resolution

Be sure you can log into SRS and that the Report Manager is functional.  Check that the ReportServer service is running, and you can use the URL referenced below to access SRS.  If SRS will not open, please consult the SQL Reporting Services Books On-line for troubleshooting tips.

In some instances, the Reporting Server Default Report Server Location is incorrect.  You can verify and\or correct this path through the NetIQ Analysis Center Console:

  • Click on Tools > Options.
  • In the left pane of the Options screen, select Reporting Services.
  • Verify the path under Default Report Server Location. By default this path is: http://<server>/ReportServer (where <server> is the name of the server where the Microsoft Reporting Services has been installed).
  • Click OK.
  • Click on View > Refresh to refresh the console view. The red 'X' should now be a green checkmark on Report Server in the Enterprise view

    Note
    : If you are using SSL, specify https for your Default Report Server Location path.

When considering the second cause, some implementations of Microsoft SQL Analysis Services requires the installation of the Decision Support Objects or Client Components.  To install these items:

  • Launch the Microsoft SQL Server Components setup.
  • Select the Install Analysis Services.
  • Follow the directions on the Welcome and License Agreement screens.
  • On the Select Components window, ensure that only Decision Support Objects and the Client Components are selected.
  • Complete the remaining steps to finish the Analysis Services installation.

If you used a non-default virtual directory name, you must reinstall SQL Reporting Services:

  • Install SQLReporting Services using non-default naming. Note: Use the default virtual directory.
  • Install Analysis Center.
  • Open Analysis Center console.
  • Add your Data Source.
  • On the AC Options page, change the URL for SQL Reporting Services to reflect the actual naming.
  • Confirm that the Reporting Services server status has changed from red to green.

Note:  Regarding Windows 2003 Service Pack 1, in some instances, SQL Reporting Services may prevent the upgrade from Analysis Center 2.0 to Analysis Center 2.1 when used in conjunction with Windows 2003 SP 1. 

To resolve the version conflict:

  1. Uninstall the SQL Reporting Services.
  2. Install Windows 2003 SP 1.
  3. Install the SQL Reporting Services again and the appropriate service packs.
  4. Install Analysis Center 2.0 SP 1 again.

Cause

Your Default Report Server Location path is incorrect or you have not installed the Analysis Services Decision Support Objects or Client Components.

Anothere cause could be that Analysis Center does not currently support SQL Reporting Services with a non default virtual directory

Additional Information

Formerly known as NETIQKB44532