cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

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

 

0 Kudos
0 Replies