NeophyteOne 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?
NeophyteThe command is for MySQL I am guessing? I am having issues with Microsoft SQL. What else can i run from debugger to test connectivity ?
NeophyteNo 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
NeophyteSQL Server Troubleshooter: MSSQLSERVER error: Read timed out ClientConnectionId:.....
SQL Server Connection Status-MSSQLSERVER sqlStatusCode 1 (General/Unknown error).
NeophyteI 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
NeophyteCan you post the error message?
