Alain Moisy said:
Looks like the DB Service is also used for testing connections when you create a CONN object. There is no clear documentation about how the test is performed so it's only having issues that I found a relation between DB Service and this feature. Maybe someone from Automic will have more information that can be verified on this topic.
Yes you are correct. DB Service is also needed in a Connection object. If you click on "Test connection" and DB Service is not started or not installed, test connection will fail with an error stating that DB service agent is not started. As to how the test is performed, I'm not sure yet.
This is also a source of confusion for most new users. Eg: They are creating an SQL job (which requires a Database/SQL Agent). But then they use a Connection object and it complains that DB Service Agent is not available.
For an SQL job, you can choose the job to connect to the database either by using a Connection object, or by specifying a Server, database, and LOGIN. If you choose the latter, then a DB Service Agent is not needed.