Hi everyone,
I have a database called CathWorldwide with a single cube called CathWorldwide and I want to restrict access to that cube. Before, I had a role and in the membership tab it had "Everyone" - which ment everyone had access to my cube. Now I changed “Everyone” to “WEBSERVER\bsci” (WEBSERVER is my domain name and bsci is a user name). Now I want to make a connection to that cube over HTTP. To simplify things I'll use the MDX Sample Application as an example. I start the MDX Sample Application, enter " in the Server textbox and "MSOLAP" in the provider textbox and click OK. I enter "bsci" in the username textbox (I also tried "WEBSERVER\bsci") and my password in the password textbox and click OK. After I click OK, it shows me a list of available databases, but my ABC database isn't there! I was able to access my ABC database when permission settings were set to "Everyone". Any suggestions on how to make it work over http would be greatly appreciated.
I have a database called CathWorldwide with a single cube called CathWorldwide and I want to restrict access to that cube. Before, I had a role and in the membership tab it had "Everyone" - which ment everyone had access to my cube. Now I changed “Everyone” to “WEBSERVER\bsci” (WEBSERVER is my domain name and bsci is a user name). Now I want to make a connection to that cube over HTTP. To simplify things I'll use the MDX Sample Application as an example. I start the MDX Sample Application, enter " in the Server textbox and "MSOLAP" in the provider textbox and click OK. I enter "bsci" in the username textbox (I also tried "WEBSERVER\bsci") and my password in the password textbox and click OK. After I click OK, it shows me a list of available databases, but my ABC database isn't there! I was able to access my ABC database when permission settings were set to "Everyone". Any suggestions on how to make it work over http would be greatly appreciated.