Forum Discussion

lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
4 days ago

SQL Server Connection Status critical alert

One of the servers added to Logic Monitor has a SQL Server Connection Status critical alert. SQL Server troubleshooter saying it's Read timed out related. How do i troubleshoot this? Permissions are correct, I can connect to SSMS on that server, proper ports are open. 

Would IPv6 be an obstacle in this case? Meaning jdbc connection string in properties would have to be changed? 

  • SQL Server Troubleshooter: MSSQLSERVER error: Read timed out ClientConnectionId:.....
    SQL Server Connection Status-MSSQLSERVER sqlStatusCode 1 (General/Unknown error). 

  • The command is for MySQL I am guessing? I am having issues with Microsoft SQL. What else can i run from debugger to test connectivity ?

    • JosiahBenoit's avatar
      JosiahBenoit
      Icon for Neophyte rankNeophyte

      No the command is to check the JDBC connections.  If you want to see if you are hitting the resource from the collector, check your wmi or sslcerts from the debugger 

       

  • WMI permissions are correct and everything WMI related is being collected in Logic Monitor. it's the SQL Connection that has critical alert. I am able to connect to the SQL Server itself but the Logic Monitor can't. I don't see any SQL or system log errors that would indicate the cause.