Login Failed Reason: Attempting to use an NT account name with SQL Server Authentication

tedburkhart
tedburkhart Registered Posts: 3 ✭✭✭✭

Having an issue with creating a MS SQL Server connection within DSS, when attempting to use an AD account to authenticate we receive the subject error. However it works fine with a SQL Server database account. Is there any way to get AD Authentication to work with MS SQL Server connections in DSS, maybe using a custom JDBC connection string.

Best Answers

  • AlexK
    AlexK Dataiker Posts: 1 Dataiker
    Answer ✓

    Hi Ted!

    Since DSS does not support Windows integrated authentication. To have jobs submitted to SQL Server as the end user, there are two options:

    1. have SQL accounts on MS SQL Server and use per user credentials as you would normally. This option is recommended for small amounts of users.

    2. Have DSS use its service account (let’s call it dataiku) to connect to the SQL server and then impersonate the end-users when accessing the database. Here is the documentation on how to do this:

    https://doc.dataiku.com/dss/latest/connecting/sql/sqlserver.html#user-impersonation-with-kerberos

    You will need to generate a keytab for the dataiku user. This option is recommended if you have a large amount of users.

    Let me know if you have any questions!

    Alex K.

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭
    Answer ✓

    Hi,

    You will unfortunately need to most likely continue using SQL Server authentication. Generally speaking, Windows authentication is only meant for and possible with software that is itself running on Windows, whereas DSS is a Linux-only installation. Therefore, this is an authentication mode that is not supported with DSS.

    Thanks,

    Andrew

Answers

Setup Info
    Tags
      Help me…