Create Project Web App Failed to Provision Databases

Create Project Web App Failed to Provision Databases

In this post, we’ll solve Create Project Web App Failed to Provision Databases in Project Server.

Create Project Web App Failed to Provision Databases

You might also like to read PWA stuck on Waiting for Resources in Project Server 2013


Create Project Web App Failed to Provision Databases

In Project Server, I tried to create and provision a new Project Web App Instance but I got  “Failed – see the Application event Log

Create Project Web App Failed to Provision Databases

To see the the application event log, you should open the Event Viewer

open event viewer

In Event Viewer, I noted that the the Project Web App can’t be created and failed to provision databases as shown below

Provision PWA: Failed to provision databases.

An Exception occurred: Failed to get schema version of Published database

Provision PWA: Failed to provision databases. An Exception occurred: Failed to get schema version of Published database

Project Server Web App Database Provisioning failed

The common Root Cause of this issue is the current login user that you are used to provision PWA instance doesn’t have a sufficient permission on SQL Instance.

Instead, you should use the farm account when you try to provision PWA instance, or provide the current login account the sufficient permission on SQL instance to be able provision and create the PWA databases properly.

You might also like to read Get PWA Instance details using PowerShell


PWA Administrator Account Permissions

To grant the PWA Administrator account the sufficient permission on SQL Server, you should do the following:

Steps

  • Open SQL Management Studio.
Open SQL Server
  • Connect to the DB Server.
Connect to SSMS
  • Below Security > Logins.
Security in SQL Server
  •  Double click on the specified administrator account user.
  • Click on “Server Roles” > Make sure that it has a “dbcreator” and “Security Admin” server role.
assign server role to sql
  • Go Back to PWA Service in Central Administration > Select “Retry” to provision the site again
retry to provision PWA
  • Great, It’s should be provisioned successfully now.
PWA Provisioned

In your side, If the issue is not a permissions issue and you already using the farm account to provision and create a Project Web App instance, so in this case, you should try to do the following:


Conclusion

In conclusion, we have granted the required permission on SQL instance to be able to provision PWA instance and avoid “Create Project Web App Failed to Provision Databases“.

Applied To
  • Project Server 2013.
  • Project Server 2010.
See Also
Have a Question?

If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.

1 thought on “Create Project Web App Failed to Provision Databases”

Leave a Reply