Hi, Im using SQL2005 with IIS6.0 and OLAP CUBE. I created one connection XMLA that work fine!. I use a Basic Authentication for Windows User and create a ROLE using dynamic security with a fact less table with relationships user+dimension, wherever i don't know how tell at ReportPortal for use this security ROLE, i think that should be a parameter of xmla connection.
To setup Analysis Services Security automatically: Programs > ReportPortal > Application Setup > XMLA Setup Security = Each user required to have NT account
You can try to setup Windows authentication on XMLA virtual directory and enable Kerberos. This way IE will authenticate the client and will pass the credentials to IIS which will pass credentials to SSAS. However, Kerberos is very tricky to setup.
quote:[i]Originally posted by admin[/i] [br]You can try to setup Windows authentication on XMLA virtual directory and enable Kerberos. This way IE will authenticate the client and will pass the credentials to IIS which will pass credentials to SSAS. However, Kerberos is very tricky to setup.
So, finally, the problem about passing user credentials through IIS 6.0 and SSAS 2005 is resolved. Without the need to configure the Protocol Kerberos !!!!. Just set up the connection "based on Windows Authentication" and most importantly is to manually edit the file \ wwwroot \ reportportal \ admin \ ConnectionXmlaProps.aspx to accept the role as XMLA connection parameters and thus takes on the role SSAS specified in the connection and user credentials security mechanism is active!. The dynamic role-based security(fact table less) is work very fine!!!
Report Portal
Pass security role to cube SSAS 2005.
Posted - 04/05/2011 : 13:35:04
