SQL service account privileges

Hello,

could you please list the permissions needed for a service account to managed MS SQL server.

I have tested connection with a user which is member of database administrators group and get below error:

Unable to log in to the asset using service account (pam_test). System connection test failed.