| T O P I C R E V I E W |
| pablohrs |
Posted - 04/05/2011 : 13:35:04
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.
Thanks for you response!
Pablo Rodriguez
Pablo H. Rodriguez Sosa |
| 5 L A T E S T R E P L I E S (Newest First) |
| pablohrs |
Posted - 05/02/2011 : 08:11:29
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!!!
Regards and Thanks anyway!
Pablo H. Rodriguez Sosa |
| pablohrs |
Posted - 04/07/2011 : 13:04:05
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.
Here are some articles on Kerberos and SSAS:
http://ssas-wiki.com/w/Articles#Kerberos
Thanks Again!!!
Pablo H. Rodriguez Sosa |
| admin |
Posted - 04/06/2011 : 18:32:53
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.
Here are some articles on Kerberos and SSAS:
http://ssas-wiki.com/w/Articles#Kerberos
|
| pablohrs |
Posted - 04/06/2011 : 12:45:31
Thanks for your reply, but wherever also i have to configurate the kerberos portocol in my network,
http://support.microsoft.com/kb/917409
Thanks again
Pablo R
Pablo H. Rodriguez Sosa |
| admin |
Posted - 04/06/2011 : 09:57:59
To setup Analysis Services Security manually please see “Analysis Services Security”:
http://www.reportportal.com/help/design/security.htm
To setup Analysis Services Security automatically:
Programs > ReportPortal > Application Setup > XMLA Setup
Security = Each user required to have NT account
|
Report Portal
