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?
Anyone else add the SCM SQL profiles to their database servers yet? Hopefully someone from the SolarWinds SCM team can answer why I can't get these profiles to work.
Did you ever get resolution? Can you share?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.