This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 72%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
I receive the following error during PSCONFIG upgrade:
Failed to upgrade SharePoint Products.
This is a critical task. You have to fix the failures before you can continue. Follow this link for more information about how to troubleshoot upgrade failures: http://go.microsoft.com/fwlink/?LinkId=259653
An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information:
Upgrade [SearchAdminDatabase Name=SearchServiceXXXXX] failed. (EventID:an59t)
Exception: User does not have permission to perform this action. (EventID:an59t)
Upgrade Timer job is exiting due to exception: System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action.
The account I'm using to run PSCONFIG has sysadmin role and is db_owner on the database.
I reviewed the log file and checked application event viewer which refers to the error above.
Does user account has db_owner permissions on all databases? Ensure that it has permissions at least on configuration database and on all content databases (you may need to go through all of them one by one and check). Although it will be simpler to add on all databases used by Sharepoint (Search, User profiles, Taxonomy, etc). Often such problems are fixed by granting shell admin rights to the current user:
Get-SPDatabase | Add-SPShellAdmin -Username CONTOSO\User1
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
@C1TonyB
It’s a known issue in the SharePoint .
As a workaround, you could use SQL Server Management Studio to review the database roles of each Search Service Application database. If you find a database role whose owner isn't "dbo," manually change the owner of the database role to "dbo." Then you can run the PSConfig tool again.
Reference:
Description of the security update for SharePoint Server 2016
Similar question:
Resolve security patch install issues on SharePoint Server 2016
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.