Product Configuration Wizard get stuck with default database permissions

[gabbsmo]

When running AutoSPInstaller with setup account as SYSADMIN, the Configuration Wizard get stuck on 10% and I see database permssion errors in the Event Viewer.

I know the script verifies that the farm service account is assigned dbcreator and securityadmin at startup. But in my experience, I need to assign the account SYSADMIN for it to work.

Reference documentation: https://learn.microsoft.com/en-us/SharePoint/install/account-permissions-and-security-settings-in-sharepoint-2013?redirectedfrom=MSDN#farm-administrator-user--account

[jn-bedag]

Yes, I think some time ago Microsoft changed something. We also have to give the sysadmin role to the install account for the initial setup. Afterwards, we leave it with dbcreator and securityadmin. Also, we always have to assign SPDataAccess role on the SP_Config database to the service account or we get the error "The EXECUTE permission was denied on the object 'proc_putObjectTVP', database 'SP_Config', schema 'dbo'."

But with this configuration, we do not have problems with the Configuration Wizard. Maybe you could provide some errors from the logfiles.

[gabbsmo]

Also, we always have to assign SPDataAccess role on the SP_Config database to the service account or we get the error "The EXECUTE permission was denied on the object 'proc_putObjectTVP', database 'SP_Config', schema 'dbo'."

Yes I see this too.

But with this configuration, we do not have problems with the Configuration Wizard.

@jn-bedag Do you mean that the Configuration Wizard works with dbcreator, security admin and SPDataAccess?

Maybe you could provide some errors from the logfiles.

Sorry, I don't have any on hand and it will probably be a while before I get to work with SharePoint Server again.

[jn-bedag]

Do you mean that the Configuration Wizard works with dbcreator, security admin and SPDataAccess?

The first run, when you create the farm, you'll need the sysadmin role. According to our experience, further executions of the Configuration Wizard do not need sysadmin rights.