Disappering users

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.

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.