Background Information
On some single-server systems, SQL Server may not fully start before the Project Server 2007 application attempts to start its Queuing service. When this happens, the Queuing service fails to start because it depends on SQL Server. You may see an error in your server’s Application Event Log similar to the one below.
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server - General
Event ID: 7882
Date: <date here>
Time: <time here>
User: N/A
Computer: <your server name here>
Description:
Unable to start service process. SSP: 62127fdc-57fd-4dec-a48a-fdac6fd04875 Service: ProjectQueueService
If your system does not require frequent reboots, simply navigating to Control Panel Ø Administrative Tools Ø Services and locating the Microsoft Office Project Server Queue Service and restarting it may be enough for your situation. If you need a more permanent solution, you can solve this problem by adding a start dependency in the system Registry.
Resolution
NOTE: This solution involves editing the Registry. Before making any Registry changes, you should always make a backup of your Registry. If you are not familiar with backing-up and restoring the Registry, familiarize yourself with these procedures before attempting to make this change
To add a start dependency in the system Registry, complete the following steps:
1. To add the key to the Registry, click Start Ø Run and type “Regedit” in the Open field. When the system opens the Registry Editor, navigate to the following folder:
HKEY_LOCAL_MACHINE Ø SYSTEM Ø CurrentControlSet Ø Services Ø ProjectQueueService
2. Select the ProjectQueueService as shown in Figure 5-84, and then click Edit Ø New Ø Multi-String Value. Name your new string value “DependonService”
3. Double click on your new DependonService string value in the right pane of the Registry window and the system displays the Edit Multi-String dialog. Add the value “MSSQLSERVER” to Value data field and click the OK button to complete your entry.