Windows authentication for SQL cluster server
We are using Database query monitor to run few queries and fetch results. It is running fine for Standalone SQL servers with windows authentication.
But for cluster server, windows authentication is not working. Later when tried with SQL authentication it worked for cluster server.
Is Sitescope configured in this way, Windows authentication for Standalone and SQL authentication for cluster servers?
Cluster server monitor details as configured in Sitescope
DB Connection URL : jdbc:sqlserver://XXXXXXXXX:21433;InstanceName=INS2
DB Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Kindly update on this.