Share
Report
67Hi friends,
I have the following situation:
1 machine with CRM 365 Version 1612 (8.2.2.112) on-premises
1 machine with :
- MS Sql Server 2016 v. 13.0.17.42.0.
- SSRS Version 13.0.1601.5
- Microsoft Dynamics CRM 2016 Reporting Extensions
We are able to acces custom reports with FetchDataSource from SSRS reports portal, but we cannot render the reports within CRM.
The error we encountered and found it in the SSRS log files is : " User was not found".
For Login into the Data source we have been trying "As the user viewing the report" and "Using windows user name and password". The Test connection has been succesfuly for the both of them.
Also, we've used the Sql Profiler and found out that the call of the stored procedure p_GetCrmUserId on MSCRM_Config does not return any record, and that's because of the @AuthInfo, which is the value for the service account that the CRM application pool runs under. That service account has no user in CRM data base (Microsoft recomandation). We think that the value for @AuthInfo should be the value of the user loged into CRM, but we don't know where and how to configure the impersonation.
Any advice, please?
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
