FINER: ConnectionID:1 Connection open - connection failed on attempt: 0.
Jan 18, 2024 9:56:19 A.M. com.microsoft.sqlserver.jdbc.SQLServerConnection login
FINER: ConnectionID:1 Connection open - connection failure. Driver error code: 0
Jan 18, 2024 9:56:19 A.M. com.microsoft.sqlserver.jdbc.SQLServerConnection login
FINER: ConnectionID:1 Connection open - sleeping milisec: 10
Jan 18, 2024 9:56:19 A.M. com.microsoft.sqlserver.jdbc.SQLServerConnection login
FINER: ConnectionID:1 Connection open - connection failed on transient error . Wait for connectRetryInterval(10)s before retry #0
Jan 18, 2024 9:56:19 A.M. com.microsoft.sqlserver.jdbc.SQLServerConnection login
FINE: ConnectionID:1 Connection open - connection retry failed on attempt number: 1
Jan 18, 2024 9:56:19 A.M. com.microsoft.sqlserver.jdbc.SQLServerConnection login
FINER: ConnectionID:1 Connection open - connection failed. Maximum connection retry count 0 reached.

        String connectionUrl = "jdbc:sqlserver://sqlao1vm1.availability.local\\DEVINSTANCE;connectRetryCount=0;trustServerCertificate=true;databaseName=master;IntegratedSecurity=true;authenticationScheme=NTLM;user=;password=;domain=availability.local;";

        Handler fh = new ConsoleHandler();
        fh.setFormatter(new SimpleFormatter());
        fh.setLevel(Level.FINER);
        Logger.getLogger("").addHandler(fh);
        Logger logger = Logger.getLogger("com.microsoft.sqlserver.jdbc.Resiliency");
        logger.setLevel(Level.FINEST);

        try (Connection con = DriverManager.getConnection(connectionUrl); Statement stmt = con.createStatement();) {
            String SQL = "SELECT GETDATE() as dt";
            ResultSet rs = stmt.executeQuery(SQL);
            // Iterate through the data in the result set and display it.
            while (rs.next()) {
                System.out.println(rs.getString("dt"));
            }
        }

        // Handle any errors that may have occurred.
        catch (SQLException e) {
            e.printStackTrace();
        }