Project General Data Access Layer error connecting to database

Summary:   This message indicates that the Data Access Layer on a Microsoft Project Server application server tried but could not connect to one of the four Project Server databases that hold the data for a Microsoft Project Server site. The effect that this problem has on the Project Server deployment varies, depending on whether the problem is caused at the server or the database level, and whether a database is affected. The following list describes how the effect on the Project Server deployment varies, depending on which database the error originated from:

1. Draft Database   Project managers will be unable to save edits to data. However, some Microsoft Project Web App functionality will be available, although typically read-only. All Reporting database read-only functionality should be available. Limited Archive database functionality will be available, but no project archive or restore functions will be available.

2. Published Database   Most system functionality will be impaired because the security data that is used for authorization is stored in this database. All Reporting database functionality should be available. However, no Archive database functionality will be available.

3. Archive Database   Most system functionality will be available except for archive and restore functions that are either scheduled or performed manually.

4. Reporting Database   Most system functionality will be available except for relational reporting.

Cause:   Possible causes include the following:

• Network connectivity issues that prevent the Project Server application servers from connecting to the one or more computers that are running Microsoft SQL Server.

• Invalid service account credentials caused by account lockouts or failure to propagate changes.

• Database availability issues caused by hardware problems, such as failed hard disk drives or controllers.

• Data access issues caused by an administrator who changes database permissions, which results in the account that is used to access data being denied authorization.

Possible resolutions include the following:

• Troubleshoot and resolve network connectivity between the Project Server application server and its SQL Server computers. For more information, see How to troubleshoot network connectivity problems (https://go.microsoft.com/fwlink/p/?LinkID=72704).

• Troubleshoot and resolve SQL Server connectivity problems. For more information, see How to troubleshoot connectivity issues in SQL Server 2000 (https://go.microsoft.com/fwlink/p/?LinkID=72705).

• Troubleshoot and recover from database issues. For more information, see INF: Disaster Recovery Articles for Microsoft SQL Server (https://go.microsoft.com/fwlink/p/?LinkID=72706).

  Note

  Once connectivity to the databases is restored, the application administrator should use the Manage Queue Jobs page in Project Web App to review the queue and take any corrective actions as indicated by the queue management documentation.

• Access the Manage Queue Jobs page

  1. Log on to Project Web App as an administrator.

  2. In the Quick Launch, click Server Settings.

  3. On the Server Settings page, in the Queue section, click Manage Queue.