How can we install the Service Catalog 17.1 rollup patch without using the "sa" account.

Document ID : KB000100772
Last Modified Date : 11/06/2018
Show Technical Document Details
Question:
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 17.1.0.1 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.
Answer:
Make the following change in the common_config.properties file, which can be found in Config folder in the installer location (\CASM-17.1.0.1-CommonPatchInstaller-Win\Config\common_config.properties)

Locate this string:

installer.skip.sysadmin.check=0

Change this value from 0 to 1, save this change and then re-run the installer.