Skip to main content
Sign In |
  Help (new window)
The World's Best Known Brand for Microsoft Project and Project Server Expertise

Project Server Experts Community Site

Go SearchAdvanced Search
Project Server Experts Community Site
Project Server Help Blog
MSProject Experts
Training Schedule
  
Project Server Experts Community Site > Project Server FAQ KnowledgeBase > Recover from removing all members of the Administrators group in Project Server 2007  

Web Part Page Title Bar image
Recover from removing all members of the Administrators group in Project Server 2007

Background Information

In Project Server 2007, it is possible to remove all members from the Administrators Group in Project Server. After doing this, nobody can logon to the system with administration rights. You can fix this in the Published database for the affected Project Server instance by adding an entry to the MSP_WEB_SECURITY_GROUP_MEMBERS table to restore a user to the administrator group.

Resolution

  1. Logon to your SQL Server Instance and expand the Published database for the affected instance
  2. Open the MSP_WEB_SECUIRTY_GROUP_MEMBERS table.
  3. To populate the WRES_GUID field in this table, copy the RES_SECURITY_GUID field for the resource from the MSP_RESOURCES table.
  4. To populate the  WSEC_GRP_GUID field, harvest the WSEC_GRP_GUID field for the Administrators group from the MSP_WEB_SECURITY_GROUPS table.
Once you restore one user, logon as that user and restore the rest of the group membership using the Administration interface. Note: It may be a good idea to restore the SSP service account first, and logon to the system using that account.