My company has developed several Analysis Services cubes for a client. They also developed an application for them to read the cubes. However, the problem comes from the fact that these cubes have to be read by anyone that accesses them, not just people belonging to the domain in which the server resides.
Now, my question is, how can they make the app so that anyone can access the cubes from anywhere, but by bypassing the Windows Authentication Procedure? This app is web-based.
I know you cannot use SQL Based authentication on Analysis Services. Is there a way I can set up IIS to maybe use the IUSR_<username> user for authentication? Maybe by adding the IUSR_<username> to the list of administrators?
Thanks,
If you set up HTTP authentication you can specify a username and password on the connection string. AS 2005 also supports allowing anonymous connections. I would not add the IUSR account to the administrators role, they only need to be added to a standard role that has rights to read the cube(s).
No comments:
Post a Comment