Excel Services 2013 secure store SSID authentication broken if global option EffectiveUserName is set


Summary:

If the Excel Services global option "Use the EffectiveUserName" is turned on, then all workbooks that use secure store service ID's (SSID) will not refresh data and can not create connections to the SSAS data sources. So effectively the SSID authentication option is not useable if the EffectiveUserName global option is turned on.

ULS entry:

ExternalSource.ValidateConnection: Unable to get a connection: … Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.TryGetValidatedConnection

Status:

The following hotfix resolves this issue:

http://support.microsoft.com/kb/2889892


Comments (0)