Freigeben über

Install SRS data connector from command prompt for SQL 2008

  • Artikel

1. Why should I install SRS data connector from command prompt ?

When installing SRS data connector on SQL 2008, we need to update installation files in order to include the newest fixes for SQL 2008.

Please see here for details:

"Support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008"

https://support.microsoft.com/kb/957053

We can choose to update the installation files when starting the graphical setup routine. In this case, the Windows update functionality will be used in order to update setup files. You need a working connection to the internet for this.

In order to exclude the possibility that we can not access windows update to update installation file, we can go ahead and install SRS data connector from command prompt. In this case, we download the newest installation files beforehand.

2. How to download newest SRS installation files ?

Please go here in order to identify the correct download links for your SRS installation files:

"948917 How to obtain the setup updates for Microsoft Dynamics CRM 4.0"

https://support.microsoft.com/default.aspx?scid=kb;EN-US;948917

You need to make sure that you check whether you have a x86 or a x64-platform. Furthermore, we need use the download link that refers to the correct base language of your CRM system (add the correct CLCID to the URL in order to make sure for language).

E.g. If you download for a German x86-platform, you need to use this URL (with CLCID 0x407)

https://go.microsoft.com/fwlink/?LinkID=104230&CLCID=0x407

Download this MSP file and save it to your SRS server.

3. How to install from command prompt ?

In order to install SRS data connector from command prompt, you need to prepare an input config-xml file. Please find a description and an example within this kb article:

"947060 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"

https://support.microsoft.com/default.aspx?scid=kb;EN-US;947060

4. How to adjust the config-xml file ?

(4.1) Adjust for the updated installation files

In order to use the updated installation files, you need to add a line to the config-xml file:

<Patch update="true">LOCATION OF SAVED FILE.MSP</Patch>

Please replace the path to the downloaded msp file.

(4.2) Adjust for a named instance

Furthermore, check your SQL Reporting configuration tool (Start, All Programs, Microsoft SQL Server, Configuration tools, Reporting Services Configuration Manager).

Check in the login screen: What is the Report Server Instance ? Is it anything other than MSSQLServer ?

- If no, you use a default instance here and you don't need an additional step.

- If yes - it is something else than MSSQLServer. Then you do use a named instance for SRS and you need to adjust this line within your config-xml file. Please replace "MyInstanceName" accordingly:

  <instancename>MyInstanceName</instancename>

(4.3) Adjust for custom reporting URL

Please login to the Reporting Services Configuration Manager (see beneath (2) ) and go to Web Service URL. Check the Report Service Web URL.

There should be one that is equivalent to the reporting URL that is used for the organization in  CRM Deployment Manager.

Please test this URL in IE (Does it work ? Can you connect to SSRS ?) and use exactly this URL in config-xml, e.g.

<reportserverurl>https://servername/Reportserver$Titan</reportserverurl>

Please replace the URL accordingly.

5. Install from command prompt

Now, you should be ready to install from command prompt by raising this command:

C:\SrsDataConnector> SetupSrsDataConnector /CONFIG path of the folder that contains the Install-config.xml file\install-config.xml

You need to use SetupSrsDataConnector from your CRM installation CD and start the setup on the SRS server.

 

Regards,

Juliane

Comments

  • Anonymous
    March 14, 2013
    I could not find SrsDataConnector folder in my Dynamics CRM installed location? How can i install Dynamics CRM Reporting Extensions? I used the following link to download Dynamics CRM 2011 mscrmonline.wordpress.com/.../microsoft-dynamics-crm-2011-downloads

  • Anonymous
    May 26, 2015
    Thanks so much Juliane. This has saved me from one full week struggle with ssrs connector for crm 4