django-sqlserver icon indicating copy to clipboard operation
django-sqlserver copied to clipboard

Windows Trusted Connection

Open wmess opened this issue 7 years ago • 1 comments

We are using: Django 1.11 / django mssql 1.8 / django-sqlserver 1.11 / python-tds 1.9.0 / sql server 2016

running on windows servers.

Does this support a trusted connection?

We currently put the database username/password in settings.py and can't get a database connection with username and password set to ''. We get an ..invalid user '' error.

Using Django channels 1.x and have the worker process running as a windows service with a valid windows account.

wmess avatar May 03 '18 19:05 wmess

I found the underlying python-tds required the use of an explicit cafile parameter and use_sso set to True in the connect() call.

Wedge009 avatar Oct 22 '24 01:10 Wedge009