Reporting Services and Analysis Services Integrate | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reporting Services and Analysis Services Integrate

It would be greatly appreciated if anyone would share experiences of issues around Integrated Security, using Kerberos Delegation in Windows 2000. Reporting Services(RS) is installed on Server A, SQL and Analysis Services are installed on Server B. When RS accesses report data stored in SQL on server B, correct Kerberos delegation is observed through the Event Viewer. When RS accesses report data stored in AS on server B, a NTLM NT AUTHORITYANONYMOUS LOGON is observed on Server B (expected a Kerberos logon). This therefore creates a "Cannot create a connection to data source" type error in RS. User credentials are required for AS as the Cube Dimensions are re-stricted via roles. After extensive readings, all Impersonation settings, Windows Integrated Security settings, Service Packs, SPNs, AD account settings have been checked, (i.e. Kerberos works when RS access SQL, but not when RS accesses AS). The basic question, what configuration is required for RS to flow the original Callers Security Context to another computer running Analysis Services. Many thanks in advance for your help.
Mark[/font=Comic Sans MS]
]]>