Reporting Services, Microsoft SQL Server, and Microsoft Dynamics CRM on separate servers RRS feed

  • Question

  • http://social.microsoft.com/Forums/en-HK/crmdeployment/thread/ec025168-9844-4ac4-b62e-3021d5ee54e7?prof=required

    Viewing the document: rssetuptfd_v2.docx (available for download from above website), I noticed I am using -

    Configuration 4: Separate Servers (Reporting Services, Microsoft SQL Server, and Microsoft Dynamics CRM on separate servers). For Data Source

    I enabled - Prompted Credentials, Use as Windows credentials when connecting to the data source.

    When users run SQL Report from SSRS report manager, they are prompted to enter username and password for every report. They are only able to

    view the data or info from the CRM Business Unit that they belong to in CRM, so crm security is working ok for SQL Reports (SQL reports -

    inhouse custom developed SQL reports - not CRM reports). Although it works as expected, I would like to implement Windows Authentication since

    it would allow users to run SQL reports without having to enter their domain logon credentials every time. I know kerberos might be the fix as

    the document (rssetuptfd_v2.docx) explains, but has anyone successfully implemented it with Configuration 4: Separate Servers.

    Monday, May 30, 2011 8:52 PM

All replies

  • Which version of CRM are you using ? If you're using CRM 4 or 2011, then it's easier to use the Reporting Services connector, as you don't need to setup Kerberos.

    However, it is possible to configure Kerberos in this scenario so that the Windows Authentication works without the need for repeated credentials. The user's IE settings will need to be set so that credentials are automatically passed to the Reporting Server, as well as the CRM Server

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, May 31, 2011 1:25 PM
  • Hi David, I am using CRM version 4.0

    CRM is installed on Server A.

    SQL Server for CRM database is SQL Server 2008 (R1), installed on Server B.

    SQL Server for Reporting Services is SQL Server 2008 R2, installed on Server C.


    I tried the CRM SRS data connector on Server C and Server B, with and without it I get same result as mentioned in previous reply (Monday, May 30, 2011 8:52 PM).


    Friday, June 3, 2011 2:29 PM