Microsoft SQL Server (MS SQL)
Windows Authentication
If you currently use Windows Authentication to connect to your database, you need to set up "mixed mode" authentication. See the documentation from Microsoft here and here. Please note, you can not use your Windows login (for example, SOMEDOMAIN\username
). You need to create a new user that has "mixed mode" enabled.
We suggest creating a read-only username of "seekwell" for your team to log in with. You or an admin will need to log in to your database and create the user, for example:
CREATE USER Mary WITH PASSWORD = '********';
This is the solution to most "Adaptive Server connection failed" errors you see when trying to connect with SeekWell.
You also need to safelist our IP address for SQL Server.