locked
Reports not working with windows integrated security RRS feed

  • Question

  • The crm reports are not working if the MSCRM_Datasource was set to "Windows intergrated security". If I change the settings to "Credentials stored securely in the report server" and "Use as Windows credentials" by providing domain user account, the reports are working fine.

    The SQL Server and reporting server resides in one server and CRM application on a different server. We installad the SSRS connector on the SQL server.

    The CRM application pool is running under network service. Please provide your suggestions to fix this.

    Thanks in advance
    Sne
    Tuesday, July 14, 2009 9:04 PM

All replies

  • There are some good recommendations on the SQL books online re the requirements to make integrated windows authentication work
    http://technet.microsoft.com/en-us/library/cc281253.aspx

    Publish one of your reports for external use (under actions on the report form) and run the report directly from the SSRS web site.  You may get some more informative error messages.

    Wednesday, July 15, 2009 3:41 AM
    Moderator
  • Hi,
    Are you using shared data source for multiple reports ?
    Vilas http://www.mscrm-vilas.blogspot.com
    Sunday, July 26, 2009 6:27 AM