Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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