In this post, we’ll solve Create Project Web App Failed to Provision Databases in Project Server.
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“
To see the the application event log, you should open the 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
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:
- Open SQL Management Studio.
- Connect to the DB Server.
- Below Security > Logins.
- Double click on the specified administrator account user.
- Click on “Server Roles” > Make sure that it has a “dbcreator” and “Security Admin” server role.
- Go Back to PWA Service in Central Administration > Select “Retry” to provision the site again
- Great, It’s should be provisioned successfully now.
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:
- If it’s the first time to provision PWA Instance, Try to delete it and create it again.
- If you are trying to migrate PWA Instance to another farm and you got this error so you must make sure that the destination farm build number is the same to the source farm and to achieve that check This content database has a schema version which is not supported in this farm.
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“.
- Project Server 2013.
- Project Server 2010.
- PWA Content Database Consideration In Project Server.
- SharePoint 2019: Service Accounts Recommendations.
- Project Server 2013 Migration from Staging to Production Farm.
- New and deprecated in Project Server 2016?
- Migrate to Project Server 2016 Step By Step
Have a Question?
If you have any related questions, please don’t hesitate to ask it at deBUG.to Community.