We are trying to configure an SCCM connector and every attempt using a valid account fails. I can ping the SCCM DB Server so that is not an issue. We tried using an AD service account that can launch the SQL Management Studio on that server, but the test connection fails. that AD account is added as a local SQL Account. We also tried using another local SQL account that is used for the Inventory DB and it also fails.
Is there a guideline document somewhere related to how the SCCM connector account should be setup?