Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FantoMax
Starting Member
1 Post |
 Posted - 2005-05-05 : 12:31:49
|
| Hi everyone,I have a database called ABC with a single cube called ABC 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\Max” (WEBSERVER is my domain name and Max is my 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 "HTTP://WEBSERVER;prompt=1" in the Server textbox and "MSOLAP" in the provider textbox and click OK. I enter "Max" in the username textbox (I also tried "WEBSERVER\Max") 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. |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-05-06 : 00:40:50
|
| Are you a member of the 'OLAP Administrator' Group? This may/may not solve the problem but at themoment this is what comes to mind. |
 |
|
|
|
|
|
Cube permissions and HTTP connection to the cube