0 Replies Latest reply on Jul 21, 2017 9:59 AM by baseliner

    Monitoring SQL Servers with Custom Query Fails with Login Failure

    baseliner

      Hi, I'm relatively new to SolarWinds and certainly new to SQL monitoring but I've imported an SQL template that uses the query below but which fails with the login failure message shown below. The account being used definitely has the required access to SQL (enabled on the SQL server security section).

       

      I did see another article (Checking SQL connection from one node to another? ), that suggested that an Agent was required when using this string but presumably the agent would need to be using appropriate credentials anyway and the template set to use the agent ?

       

       

      Driver={SQL Server};Server=${IP},1433;DataBase={master};Uid=${USER};Pwd=${PASSWORD};

       

      2017-07-21 15_46_34-RE_ SQL Monitoring.jpg