When you install Patch Manager, you have the option of using a local SQL server or a remote server for the Patch Manager database. In either case, Patch Manager requires two accounts to interface with the SQL server:
Patch Manager requires the following of the service account, depending on the deployment option you choose.
Note: If you choose to run Patch Manager with a remote SQL server, Patch Manager has the additional requirement noted in this list. This allows the service account to maintain a connection to the remote SQL server.
Some users have questioned whether Patch Manager requires the remote SQL server to have mixed-mode authentication enabled. Patch Manager does not have this additional requirement, despite the fact it utilizes both a Windows account and a SQL account. The reporting account is a least-privilege account that only requires permission to connect and execute
SELECT statements. Since it does not require SysAdmin permissions, mixed-mode authentication is not necessary.