本文介绍了无法从SSRS连接到远程MS Dynamics CRM Fetch XML数据源的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有带有Microsoft Dynamics CRM的Office 365,其中包含业务数据,并且我在作为报告容器的独立服务器上具有SQL Server Reporting Services,并且我的ASP.NET网站可以执行这些报告,并且人们可以在其中部署报告

I have Office 365 with Microsoft Dynamics CRM which contains business data and I have SQL Server Reporting Services on a stand-alone server that serves as a report container and my ASP.NET websites can execute these reports and people can deploy reports there.

在Visual Studio中,我为提供CRM服务器凭据的报表创建了Fetch XML数据源,报表运行平稳,完全没有问题.当我将其部署到SSRS服务器上时,无法使用相同的凭据执行它,它只会引发以下错误:

In Visual Studio I've created Fetch XML datasource for my report supplying CRM server credentials and report runs smoothly, no problems at all. When I deploy it on SSRS server I can't execute it with the same credentials, it just throws following error:

好的,没什么大不了的.我用Google搜索它,并找到了,我必须输入 SystemUserId 凭据中的> OrganizationId ,尽管我无法直接在SQL Server上查询它们,但我设法通过MS Dynamic CRM获取了这些值.在数据源的登录名和密码输入中输入它们,然后单击测试连接",然后出现此错误:

Ok, no big deal. I googled it and found out I had to enter SystemUserId and OrganizationId in credentials, although I couldn't query them directly on SQL Server I managed to get these values through MS Dynamic CRM. Entered them in datasource's login and password inputs, clicked "Test connection" and I got this error:

好吧,再次谷歌搜索,显然我必须修复SQL Server用户权限,并且我无权(也永远不会)访问MS Dynamics CRM的SQL Server来解决权限问题.为什么它可以在Visual Studio中运行,但在SSRS服务器上却无法运行?我该如何解决此对接问题?谢谢.

Ok, google it again and obviously I have to fix SQL Server user permissions and I don't have any access (and never will) to MS Dynamics CRM's SQL Server to fix permissions issue. Why does it work in Visual Studio, but fails on SSRS server? What do I do to fix this conenction issue? Thanks.

推荐答案

您将无法在Dynamics CRM Online实例上本地运行Fetch XML报告.您需要将这些报表部署到Dynamics CRM Online组织,然后从Dynamics CRM运行它们.

You will not be able to run Fetch XML reports locally against a Dynamics CRM Online instance. You would need to deploy those reports to the Dynamics CRM Online organization and run them from Dynamics CRM.

它可以在Visual Studio中使用,因为CRM Report Development扩展使其可以用于开发,但是不能直接部署到SSRS服务器-Fetch XML报表只能通过Dynamics CRM部署到CRM中配置的SSRS服务器.

It works in Visual Studio because the CRM Report Development extension makes it work for development, but it cannot be deployed directly to an SSRS server - the Fetch XML reports can only be deployed through Dynamics CRM to the SSRS server configured in CRM.

这篇关于无法从SSRS连接到远程MS Dynamics CRM Fetch XML数据源的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-15 19:46
查看更多