Hello.
I have an SQL 2000 OLAP (SP4) project with lots of dimensions, mesures, cubes, roles and users. Everything was fine for a year till yesterday. I've added a user (did it time to time before) to a role. As I process the cube the user was removed from the role. Now I can not add anyone. Am planning to remove everyone and add again. But also scared of adding nobody forever.
Help. Thanks.
Disappering users
jsc7810
I wonder if perhaps one or more of the users in some of the roles are no longer valid in the domain I would suggest making a backup of your database and then perhaps by removing the roles and re-adding the (valid) users you'll get back to a good state.
Hope that helps.