We have SC installed using a fix, T6D9364, which allows us to install without requiring sys admin privileges in Sql Server. When applying the Service Management 22.214.171.124 patch the installer issues the following error message: 'DBA User do not have sysadmin privilege. Please provide the user with sysadmin privilege'. How can we install the Service Catalog 17.1 rollup patch without using the "sa" account.
Make the following change in the common_config.properties file, which can be found in Config folder in the installer location (\CASM-126.96.36.199-CommonPatchInstaller-Win\Config\common_config.properties)
Locate this string:
Change this value from 0 to 1, save this change and then re-run the installer.