After building multiple 2019 environment successfully with out any error I notice PSConfig fails when run with Admin/install account with the error message shown below. PSConfig completes succesfully when run with farm account.
Its complaining about the .dbo rights for two service applications only (bdc and secure store) in all environments.
Have you guys seen the same behavior ? How we dealing with this if want to run PSConfig under admin/install account and not farm account.
Failed to upgrade SharePoint Products. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: CanUpgrade [BdcServiceDatabase Name=SP_BusinessDataCatalog] failed. (EventID:an58c) Exception: Cannot open database "SP_BusinessDataCatalog" requested by the login. The login failed.Login failed for user 'Domain\Admin'. (EventID:an58c) Cannot upgrade [BdcServiceDatabase Name=SP_BusinessDataCatalog]. (EventID:an59g) CanUpgrade [SecureStoreServiceDatabase Name=SP_SecureStore] failed. (EventID:an58c) Exception: Cannot open database "SP_SecureStore" requested by the login. The login failed.Login failed for user 'Domain\Admin'. (EventID:an58c) Cannot upgrade [SecureStoreServiceDatabase Name=SP_SecureStore]. (EventID:an59g) Upgrade completed with errors. Review the upgrade log file located in E:\SP\Upgrade-20200615-104655- 975-4f9faad470f04d01a49e45ecc57c4f81.log. The number of errors and warnings is listed at the end of the upgrade log fil e.
After building multiple 2019 environment successfully with out any error I notice PSConfig fails when run with Admin/install account with the error message shown below. PSConfig completes succesfully when run with farm account. Its complaining about the .dbo rights for two service applications only (bdc and secure store) in all environments. Have you guys seen the same behavior ? How we dealing with this if want to run PSConfig under admin/install account and not farm account.
Failed to upgrade SharePoint Products. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: CanUpgrade [BdcServiceDatabase Name=SP_BusinessDataCatalog] failed. (EventID:an58c) Exception: Cannot open database "SP_BusinessDataCatalog" requested by the login. The login failed.Login failed for user 'Domain\Admin'. (EventID:an58c) Cannot upgrade [BdcServiceDatabase Name=SP_BusinessDataCatalog]. (EventID:an59g) CanUpgrade [SecureStoreServiceDatabase Name=SP_SecureStore] failed. (EventID:an58c) Exception: Cannot open database "SP_SecureStore" requested by the login. The login failed.Login failed for user 'Domain\Admin'. (EventID:an58c) Cannot upgrade [SecureStoreServiceDatabase Name=SP_SecureStore]. (EventID:an59g) Upgrade completed with errors. Review the upgrade log file located in E:\SP\Upgrade-20200615-104655- 975-4f9faad470f04d01a49e45ecc57c4f81.log. The number of errors and warnings is listed at the end of the upgrade log fil e.