There are several instances in PS2010 where the AD Resource Sync is partially failing and causing active resources to be deactivated in Project Server. One of the causes is mismatch of the AD GUID. This can happen either if the account was removed from AD then re-added, or if the PS account was created manually. The solution to this is simple. Using the SQL statements below, the mis-mapping on an account can be removed. Then the AD sync will repair the mis-match on the GUID when the next Synchronization occurs.

Using SQL Server Management studio, create a query against the Published Database for the affected PS instance.

 

-- Identify the entry for the affected user

SELECT RES_UID,RES_NAME, WRES_AD_GUID FROM MSP_RESOURCES

WITH(NOLOCK)

ORDER BY RES_NAME

-- Copy the RES_UID from the entry for use in the following queries in place -- of [RES_UID]

 

-- Modify the user entry to make the WRES_AD_GUID Null

UPDATE MSP_RESOURCES

SET WRES_AD_GUID=NULL

WHERE RES_UID ='[RES_UID]'

 

--Verify the change

SELECT * FROM MSP_RESOURCES

WHERE RES_UID ='[RES_UID]'

 

When the next Active Directory Synchronization occurs, the WRES_AD_GUID should be re-populated with the correct value, and the user should appear active in Project Server.