search

livehelpnow / tds_ecto

TDS Adapter for Ecto
57 stars 34 forks source link

Support Windows Authentication #29

Open sds88 opened 8 years ago

sds88 commented 8 years ago

It would be nice if this could support windows authentication to log in instead of using a username/password in the config.

For reference, the connection string to use windows auth looks something like Server=MyServer;Database=MyDb;Trusted_Connection=Yes;

h2ounderthebridge commented 8 years ago

+1

mjaric commented 7 years ago

This should be possible to implement for windows OS, but for linux I'm not sure if any other option than kerberos authentication with explicit credentials is possible. I would appreciate if anyone can provide me a link to good article/manual how to join linux server into Windows Domain, so I could do research if this could be done for linux OS without using explicit username/password in configuration. Otherwise, there is no use to have domain user credentials laying around in configuration files.

There is repo for nif version for rabbitmq kernel authentication.

Anyhow, I don't think this is an easy task after all it is much easier to create sql login. It is also possible to have tsl connection and authentication which is by far better approach when it is required to have secured connection due to compliance requirements.

jiri-bati-novak commented 6 years ago

I would like to +1 this feature, as I am a bit stuck - my db admins are not willing to enable sql auth on db server I need to connect to, and only way to connect with windows auth from linux is golang mssql driver (github.com/denisenkom/go-mssqldb), so at the moment I am getting data via golang "api server" :)

srjobinar commented 5 years ago

+1, even my db admins does not allow sql authentication. Can this be implemented for atleast windows?

tymoor commented 3 years ago

+1