locked
CRM Reporting server accessing error ? RRS feed

  • Question

  • Hello,

    Case : we have two crm servers pointing to single sql server but two different sql instance, so my query is : when i click on report not able to view and my report server for both crm server should be same (means on single sql box).

    Error : Reporting Error when running report in CRM - rsAccessDenied.

    Any help is appreciated...thanks!


    Saturday, August 20, 2011 8:20 AM

Answers

  • Are you trying to use the CRM Reporting Services connector ? I don't believe that you can use the connector for both deployments in the configuration that you have. The connector can only be configured for one CRM deployment per RS server
    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
    Monday, August 22, 2011 6:00 AM
    Moderator

All replies

  • Hi,

    In SSRS server look for ReportServerWebApp_<timestamp>.log and ReportServer_<timestamp>.log log files located at <Microsoft SQL Server Dir>\<SQL Server Instance>\Reporting Services\LogFiles


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Saturday, August 20, 2011 11:14 AM
  • Are you trying to use the CRM Reporting Services connector ? I don't believe that you can use the connector for both deployments in the configuration that you have. The connector can only be configured for one CRM deployment per RS server
    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
    Monday, August 22, 2011 6:00 AM
    Moderator
  • The wizard should warn telling than the RS connector is already installed and probably stops the installation.

    Thursday, August 25, 2011 2:17 PM