locked
CRM2011 Report with data from external database - which grants are needed RRS feed

  • Question

  • Dear all, 

    I am building a report with data from both CRM and non-CRM database. Report will  be run from "inside" of CRM.

    Which steps (creating logins and grants) do I need to do in in this non-CRM database ?

    Cheers,

    PEKKA


    Pekka

    Thursday, March 6, 2014 6:14 PM

All replies

  • It depends how you setup the DataSource to the non-CRM database in the report. CRM will not change this DataSource when you deploy the report via CRM.

    Is the non-CRM database a SQL Server database,or something else ? If it's SQL Server, do you use Integrated Security


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, March 6, 2014 9:41 PM
    Moderator
  • David, external db here is a sql-database in the same sqlserver as the MSCRM db. Question is about Access rights. I have once seen a blog entry about this (how to grant Access right for CRMReportingGroup ?) but I do not seem to able to find that entry anymore.

    PEKKA


    Pekka

    Friday, March 7, 2014 5:49 AM