解决在Azure SharePoint 2013 “在为项或数据源“FirstRSDS.rsds”加载模型时出现错误。请确认连接信息正确并且您有权访问该数据源。”

解决在Azure SharePoint 2013  “在为项或数据源“FirstRSDS.rsds”加载模型时出现错误。请确认连接信息正确并且您有权访问该数据源。”

错误抓图如下

错误描述

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">在为项或数据源“FirstRSDS.rsds”加载模型时出现错误。请确认连接信息正确并且您有权访问该数据源。</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=12.0.4100.1</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">12.0.4100.1</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">2052</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=12.0.4100.1" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">在为项或数据源“FirstRSDS.rsds”加载模型时出现错误。请确认连接信息正确并且您有权访问该数据源。</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorOpeningConnection&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=12.0.4100.1" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">无法与数据源“FirstRSDS.rsds”建立连接。</Message><MoreInformation><Source>Microsoft.AnalysisServices.AdomdClient</Source><Message></Message><MoreInformation><Source>Microsoft.AnalysisServices.SPClient</Source><Message>对象的当前状态使该操作无效。</Message></MoreInformation></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

这是数据源认证的错误。

需要修改认证，如下图 就搞定了，前提是你的kerberos 已经配置成功了。 

保存 就ok了，开发效果图如下。

关于Kerberos 的配置方法。

http://blog.csdn.net/duanchuanttao/article/details/44343681