Design Tool and Security roles

I have 2005 SP1 and after adding the new users to the Server in Studio, I go to the Design tool and create a new role, I add the user and check the following: process database and read definition.

I then go to Cell Data Tab and select Test Cube Secuirty; when asked if I want to deploy the cube I say "yes". after I deploy it I get the following message: "You are browing the cube using credential of the following roles: Sales" then I get the message below that

"Connection can not be made. Ensure the server is running" and

No connection could be made because the target server actively refused it.

I am connected to the cube so its running, remote connection are allowed, I already connected, just attempting to define and test other roles? Is there an issue with Test cube security? any suggestions?

Try to re-connect your Cube browser after deploying the solution.

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

|||Yes, I do reconnect to my cube but I always get the error message, I can't test security, even though the roles I defined do allow the users to access the cube I still get this message. Thank you,|||

It is a bit strang situation.

What worries me is that you say "adding the new users to the Server in Studio, I go to the Design tool and create a new role".

You should'nt go and manage your security in different places. If you to add uses in SQL Management Studio, next time you deploy your solution, Role memebership will get overwritten. Try to make all the changes in BI Dev Studio.

I would also recommend you upgrde your Analysis Services to SP2.

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

|||

Edward,

Maybe I miscommunicated that, I do make them in the design tool, I keep all my roles in the BI tool but I started to try to test them there before I deploy them and I can't test them that was my error. When I go to CELL Data and select "test Cube Security" I get the error.

Thank you,

Janet

|||

One litte trick to troubleshoot your problem.

Try deploying the solution from BI Dev Studio. Process it. Then go back to SQL Management Studio and try to browse your cube under different user or role to test your securtiy.

HTH

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

|||

Hi Edward,

I don't know how to browse the cube under a different role in SQL Managment Studio.

I think we have moved onto a different direction, let me try to explain a little better.

All my roles actually work when the user accesses the cube the defect or error is I can't "test the role" in BI Development tool. If I select a role that I know actully works and attempt to do the test from I go to the "Cell Data" tab and click on Test Cube Security using a role that I know allows the user access I get this message " your are browing a cube using the following role: process and read" - connection can not be made insure the server is running. But if i check with the users in that role, all the users in that role can access the cube.

So my problem is not that the role is not allowing access, its that Test Cube Security gives me a bogus error, because that role can access and browse the cube.

Thank you,

Janet

|||

Just wondering does the "test cube security" actually work in the BI tool for everyone but me? is anyone else having this problem?

thank you