How to give "public" access to cubes

Question

Hi,

I'm deploying cubes over an intranet on web pages using OWC (OWC11).

We can create roles to restrict access to dimensions or even the whole cube itself. On the intranet I must give access to everyone, that is users who are not registered on AS2005 Server.

How can I give an Anonymous access over my cubes to my cube readers such that anyone can view the cube?

 I've created a role named "public" in which I've added Anonymous Logon but OWC still denies access to non registered users.

Thanks.

Answer 1

Try and change RequireClientAuthentication Analysis Serverv property.

The description of it you can find here: http://msdn2.microsoft.com/en-us/library/ms174771.aspx

And here: http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/SSASProperties.doc

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Dear Edward,

I've changed my Ananysis Server Property : RequireClientAuthentification set to false.

The clients still don't have access to the OWC pivot table on the web page. I get the following error translated from french:

" Error in the OLE DB provider. Impossible to connect to the redirector. Verify that the SQL Browser service is on execution on the server "server_IP_address".

Error in the OLEDB provider. An error have occurred in the data extraction from a named instance from the SQL Browser service on the server " server_IP_address" ".

OWC11 and SQL Server Analysis Services 9.0 OLEDB Provider are installed on the client machines.

It seems that OWC is not allowing anonymous connections. Any clues?

Thanks.

Answer 3

This could be something else. Some connectivity problems. Take a look at this http://www.sqljunkies.com/WebLog/edwardm/

You should find your error there and some clues how to troubleshoot connectivity.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

Can't you assign appropriate (read) privileges to the Everyone group?