Kerberos with Report Server

Arez2017 — Wed, 21 Feb 2018 16:21:28 GMT

Hello Community,　

I have created 3 servers on wich I have installed : PowerBI Report Server, SSAS and SQL Server.　

I have configured Kerberos.　

However, it is not working 　

We couldn't run the report because we couldn't connect to its data source. The report or data source might not be configured correctly.
Please try again later or contact support. If you contact support, please provide these details.　

We couldn't connect to the Analysis Services server. The server forcibly closed the connection. To connect as the user viewing the report, your organization must have configured Kerberos constrained delegation.　

Request ID9115842d-13ca-19f4-da04-93a824f9e0b8　

TimeWed Feb 21 2018 17:12:06 GMT+0100 (Romance Standard Time)　

Version14.0.600.442　

in log files :　

2018-02-21 17:12:06.1462|ERROR|10|PBI.Win.ReportingServicesHostTrace|type:Error;message:processing:Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'EntityDataSource'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host　

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)　

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)　

--- End of inner exception stack trace ---　

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)　

at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)　

at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)　

at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()　

at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()　

at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()　

--- End of inner exception stack trace ---　

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)　

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)　

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperty(String propName)　

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)　

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)　

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)　

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()　

at Microsoft.ReportingServices.DataExtensions.AdomdExceptionHandler.Execute(String connectionString, Action action)　

at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass6_0.<OpenConnection>b__0()　

--- End of inner exception stack trace ---;;| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae 　

2018-02-21 17:12:06.1618|ERROR|10|PBI.Win.ProcessingError|ExceptionType:Microsoft.ReportingServices.ReportProcessing.ReportProcessingException;stackTrace: at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass6_0.<OpenConnection>b__0()　

at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action)　

at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5_0.<OpenDataSourceExtensionConnection>b__0()　

at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction)　

at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)　

at Microsoft.PowerBI.ReportingServicesHost.LocalDataExtensionConnectionWrapper..ctor(DataSourceInfo dataSourceInfo, CreateDataExtensionInstance createExtensionCallback, UserContext threadUser, ExecutionType execType, IAdditionalToken additionalToken, IDbConnectionPool connectionPool, IDataProtection dataProtection)　

at Microsoft.PowerBI.ReportingServicesHost.LocalDataExtensionConnectionWrapper.<>c__DisplayClass7_0.<Open>b__0()　

at Microsoft.PowerBI.ReportServer.ExploreHost.WindowsUserIdentityConnectionImpersonator.ExecuteInContext[T](Func`1 func)　

at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService)　

at Microsoft.PowerBI.ReportingServicesHost.DataShapingHelper.GetModelMetadata(IPowerViewEngine powerViewEngine, IDbConnectionPool connectionPool, DataSourceInfo dataSourceInfo, IASConnectionInfo asConnectionInfo, Boolean useMsolapForCsdl, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService, String maxModelMetadataVersion);message:GetModelAsStream;| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae 　

2018-02-21 17:12:06.1774|ERROR|4|Failure in conceptualschema| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae Microsoft.PowerBI.ReportServer.ExploreHost.Error.RSExploreHostException: Cannot create a connection to data source 'EntityDataSource'. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'EntityDataSource'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host　