B
Bara
I have managed to finally get the Cube to build and have scheduled it in
Project Server 2007 to build once a day.
The problem is that each time it builds it seems to lose the Database Role
settings in AS2000. The only role that remains is an administrator account
that has access which means the views no longer work in Project Web Access.
I can manually add Domain Users to have access but this is lost each day.
Any ideas why the roles are lost/how to get it to keep a standard role on
the AS cube?
I haev checked all the SQL & project services and none of them run as this
administrator users so I am unsure where this is coming from.
Project Server 2007 to build once a day.
The problem is that each time it builds it seems to lose the Database Role
settings in AS2000. The only role that remains is an administrator account
that has access which means the views no longer work in Project Web Access.
I can manually add Domain Users to have access but this is lost each day.
Any ideas why the roles are lost/how to get it to keep a standard role on
the AS cube?
I haev checked all the SQL & project services and none of them run as this
administrator users so I am unsure where this is coming from.