Forum Discussion

lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
4 months 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 ...
lmproduct
lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
4 months ago

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

  • JosiahBenoit's avatar
    JosiahBenoit
    Icon for Neophyte rankNeophyte
    4 months ago

    I would run the debugger command just to check the auth strings are correct                      !jdbc [auth=login|integrated] [username=xxx [password=yyy]] url='<jdbc:mysql://host:port/database?user=xxx&password=yyy>' sql

    If 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