MSSQL Health Checks Supported Authentication Models
My apologies if this not the correct forum to post this question. but since my question is releated to MS SQL i thought this might be a good spot.
I have been asked to load balance a pair of SQL servers behing an LTM running 10.2.0 which is working quite well. Our DBA has provided me with a SQL query to use as the basis of a custom MSSQL health Monitor he would like me to apply to the Pool members to verify that database is available. we only use intergrated authentication for access to the sql database not native SQL auth. Can the health monitor be configured to use and AD credential and password when it queries the database? when i apply this health monitor it fails and we can see in the sql logs that the authentcation failed, with a AD domain account.