[QUESTION] Connecting using "domain credentials"

[djl0]

Hi everyone - I'm running myself in circles, and I was hoping someone might be able to shed some light on my situation. The credentials I was given from the DB admin was in the form of "domain\username". When I connect in Pycharm, it uses what it calls "domain credentials". I'm using a python-slim docker image and ODBC Driver 17. In my settings.py, I've tried every combination of domain and username in the user, host, instance fields with no success (still getting "login failed"). I saw an issue (linked below) where someone said "windows authentication" doesn't work; is my auth-style that? Or I'm seeing these extra flags that refer to Active directory.

Any help is greatly appreciated.

Relevant Issues and Pull Requests
Is this the same issue as here?
That refers to this: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-containers-ad-auth-adutil-tutorial?view=sql-server-ver16

[mShan0]

It seems like you're using Windows authentication based on the "domain\username" format. Does your machine have permissions to connect to your database?

The issue you linked is not related unless your SQL server is running on a Linux-based machine.

[dauinsight]

If you are using windows authentication, please remove the "USER" and "PASSWORD" field.

[djl0]

@mShan0 @dauinsight Thanks for your replies!

It seems like you're using Windows authentication based on the "domain\username" format. Does your machine have permissions to connect to your database?

I can connect using Pycharm (not in the docker container), so I would think so. The Pycharm connection parameters look pretty basic (ie there aren't any extra flags that I can see, aside from the authentication being "domain credentials").

If you are using windows authentication, please remove the "USER" and "PASSWORD" field.

Then how would I pass the USER & PASSWORD? I took those parameters out, and the message was No Kerberos Credentials Available

Another question: Should the domain in domain\username be domain in the extra parameters string?

Thanks!

[mShan0]

Your DATABASES should look something like this

DATABASES = {
    "default": {
        "ENGINE": "mssql",
        "NAME": "my_database_name",
        "USER": "DOMAIN\\username", # 2 of "\" to escape the character
        "HOST": "localhost", # or DB's IP address
        "PORT": "1433",
        "OPTIONS": {"driver": "ODBC Driver 18 for SQL Server", 
                    "extra_params": "Trusted_Connection=Yes;"},
    },
}

Did connecting with PyCharm only work when you provided a password?

[djl0]

I tried the database parameters above (though I have ODBD Driver 17 installed), and I still got the same No Kerberos Credentials available error. And I did have to use the password when using Pycharm.

I'm thinking of creating a FreeTDS docker container to give that a try. I believe the server is SQL Server 11 (2012?), would that mean I should use an earlier driver, or would FreeTDS be a better option?