SQL Server Connection Status critical alert

Question

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.&nbsp;Would IPv6 be an obstacle in this case? Meaning jdbc connection string in properties would have to be changed?&nbsp;

josiahbenoit · Answer

Can you post the error message?&nbsp;

lucjad · Answer

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

josiahbenoit · Answer

I would run the debugger command just to check the auth strings are correct&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; !jdbc [auth=login|integrated] [username=xxx [password=yyy]] url='&lt;jdbc:mysql://host:port/database?user=xxx&amp;password=yyy&gt;' sqlIf that not the issue I would suggest using the SQLCheck tool to see what's going on https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/SQLCHECK&nbsp;

lucjad · Answer

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 · Answer

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