SCM - MS SQL Server Essentials Connection Error

I'm receiving an error <ERROR [28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user... > when attempting to use the MS SQL Server Essentials profile for the first time.  I noticed that the connection string is:  Driver={ODBC Driver 17 for SQL Server};Server=${NodeIP};Uid=${Username}; Pwd=${Password};, which if I read the online documentation correctly is for SQL version 2019. 

I'm running on 2016, so I created a new profile and replaced the connection string to Driver={ODBC Driver 13 for SQL Server};Server=${NodeIP};Uid=${Username}; Pwd=${Password};.  Now I receive the below error.  Has anyone set this profile up for a 2016 DB?  If so, can you help me out?

s-bolyard_0-1599683422729.png

Top Replies

Parents Reply
  • Sorry , just saw this message.  I worked with SolarWinds support and I guess for these SQL queries to run you have to have a local account on the SQL database server you are monitoring.  I was using a domain account to connect and I guess that won't work.  Once I added the local SQL account on the database destination server, it worked fine.  Unfortunately I'm going to have to add a local account to all the database servers we want to monitor.  

Children