Error message in the Environmental Diagnostic wizard when you try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services: "Unable to validate SQL Server Reporting Services Report Server installation"

Article translations Article translations
Article ID: 947060 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

After you install Microsoft Dynamics CRM 4.0, you try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services. When you run the Environmental Diagnostic wizard, you receive the following error message:
Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine.

CAUSE

This problem may occur if one of the following conditions is true:
  • You try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a server that is not running Microsoft SQL Server 2005 Reporting Services (SSRS).
  • You try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a named instance of SQL Server 2005 Reporting Services.
  • You try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a SQL Server 2005 Reporting Services installation that uses a nondefault Web site.

RESOLUTION

To resolve this problem, use one of the following methods.

Method 1: Install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a server that is running SQL Server 2005 Reporting Services

To install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services, you must run the installation on a server that is running SQL Server 2005 Reporting Services.

Method 2: Modify the Install-config.xml file

Use this method to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a named instance. Additionally, use this method if the Reporting Services installation uses a nondefault Web site.

Modify the Install-config.xml file. Then, run the SetupSrsDataConnector command. To do this, follow these steps:
  1. Copy all the files in the SrsDataConnector folder on the installation CD to a folder on drive C. For example, copy the files to the following folder:
    C:\SrsDataConnector
    Note The SrsDataConnector folder is located in the following folder on the installation CD:
    drive:\Server\i386
    The drive placeholder represents the CD drive.
  2. Locate the folder in which you copied the installation files. Right-click the Install-config.xml file, and then open the file in Notepad.
  3. Add the following information to the Install-config.xml file:
    • The reportserverurl tags
    • The URL for the server that is running SQL Server 2005 Reporting Services
    For example, if the server that is running Reporting Services has a named instance of Titan, the reportserverurl tags resemble the following example.
    <reportserverurl>http://servername/Reportserver$Titan</reportserverurl>
    
  4. If the server that is running SQL Server 2005 Reporting Services has a named instance, modify the instancename tags.

    For example, if the server that is running Reporting Services has a named instance of Titan, the instancename tags resemble the following example.
    <instancename>Titan</instancename>
    
  5. After you complete steps 3 and 4, click Save on the File menu, and then close the Install-config.xml file. The Install-config.xml file should resemble the following example.
    <crmsetup>
      <srsdataconnector>
        <configdbserver></configdbserver>
        <autoupdateconfigdb>1</autoupdateconfigdb>
        <reportserverurl>http://servername/Reportserver$Titan</reportserverurl>
        <autogroupmanagementoff>0</autogroupmanagementoff>
        <instancename>Titan</instancename>
        <configsku>OnPremise</configsku>
        <!-- Set enabled = true for DB webstore integration.  Set configdb="true" for config db webstore integration-->
        <webstore enabled="false" configdb="false" />
        <monitoring>
    <!-- Monitoring service account name and password. It can not be local system or network service account -->
          <serviceaccountname></serviceaccountname>
          <serviceaccountpassword></serviceaccountpassword>
        </monitoring>
      </srsdataconnector>
    </crmsetup>
    
  6. Open a Command Prompt window, and then locate the folder in which you copied the installation files in step 1.
  7. At the command prompt, type the following command, and then press ENTER:
    C:\SrsDataConnector> SetupSrsDataConnector /CONFIG path of the folder that contains the Install-config.xml file\install-config.xml

MORE INFORMATION

For more information about how to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services, see pages 7 through 58 in the installation guide.

Properties

Article ID: 947060 - Last Review: September 12, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Dynamics CRM 4.0
  • Microsoft Dynamics CRM Connector for SQL Server Reporting Services, when used with:
    • Microsoft Dynamics CRM 4.0
Keywords: 
kberrmsg kbsetup kbinstallation kbmbsreports kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB947060

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com