[QUESTION] Connecting using "domain credentials" about mssql-django HOT 5 OPEN

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.

from mssql-django.

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

from mssql-django.

@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!

from mssql-django.

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?

from mssql-django.

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?

from mssql-django.