Forum Discussion

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

SQL Server Connection Status critical

I added SQL server to Logic Monitor. All properties are correct. I have SQL Server Connection Status critical error: Database connection returned an error of 1.0 on ......
Value 1 : General/Unknown error. I also have SQL Server Troubleshooter with this message: MSSQLSERVER error: Read timed out ClientConnectionId: .....

SQL related data sources are not getting any data for monitoring. 

WMI permissions are correct. SQL permissions seem to be correct too. 

I am not sure what is the Read timed out message related to. Any ideas how to troubleshoot this issue? 

lmproduct
  • lucjad's avatar
    lucjad
    Icon for Neophyte rankNeophyte
    2 days ago

    Yes, I ran the scripts from link you attached. Logic Modules are up to date. 

    Is the Remote Registry service supposed to be running? Is this a requirements for Logic Monitor to be able to communicate with SQL Server? 

    • Mike_Moniz's avatar
      Mike_Moniz
      Icon for Professor rankProfessor
      23 hours ago

      I can't confirm if it's required, but it is running for an example I checked. Might be on for other reasons. Would be worth temporarily starting it to see if it helps you though.

  • lucjad's avatar
    lucjad
    Icon for Neophyte rankNeophyte
    3 hours ago

    It didn't seem to help. Are there other services that need to be running?