Translate SQL Client Conn to Sling config

[nyc-de]

Hi,

I have a SQL serve instance that I can connect to using a SQL client but I can seem to translate it to a sling connection string.

Is anyone familiar with SQL Server and Azure AD who can help me with this.

I have included a screenshot of the SQL client.

The tooltip for 'Domain' says 'Set domain to be logged in using Windows Integrated Authentication (NTLM)'

[flarco]

Hey, since you have SSL enabled, Trust Server Certificate checked, and a domain, can you try:

connections:
  MSSQL:
    type: sqlserver
    host: MY_HOST
    instance: MY_INSTANCE
    port: 1433
    user: my_user
    password: my_password
    database: MY_DB
    encrypt: 'true'
    trust_server_certificate: 'true'

For Windows Domain Authentication:

If you want to use Windows domain authentication (since you have a domain specified), you can use:

connections:
  MSSQL:
    type: sqlserver
    host: MY_HOST
    instance: MY_INSTANCE
    database: MY_DB
    encrypt: 'true'
    trust_server_certificate: 'true'
    trusted_connection: 'true'

• encrypt=true - Because you have SSL enabled
• • trust_server_certificate=true - Because you have "Trust Server Certificate" checked
• • instance=MY_INSTANCE - Your SQL Server instance name
• • database=MY_DB - Your default database

Testing the Connection:

Once configured, test with:

sling conns test MSSQL

[nyc-de]

Hi,

Thanks a ton for the reply.

Still can't successfully connect with Sling.

Should I have mentioned I'm on a Mac trying to use Windows Integrated Authentication?

The first suggestions yields:

fatal:
~ could not connect to database
mssql: login error: Login failed for user 'my_user'.

The second config

fatal:
~ could not connect to database
mssql: login error: Login failed for user ''.

I've been plowing through combinations for a week now.

Is a config using Kerberos an option here or would I be wasting my time pursuing?

[flarco]

Yeah you can give it a try using the kerberos params: https://docs.slingdata.io/connections/database-connections/sqlserver#kerberos-parameters

[nyc-de]

I got this working and putting here for future poor souls.

The username should be prefixed with you AD url separated by a url encoded '' so %5C<my_username>

type: sqlserver
authenticator: ntlm
database: my_db
encrypt: "true"
host: my_host
instance: my_instance_name
password: my_password
port: my_port
trust_server_certificate: "true"
user: %5C<my_username>