search

justinlettau / sql-source-control

Simple CLI for getting SQL into source control systems.
MIT License
53 stars 22 forks source link

Windows authentication support #63

Open unybble opened 5 years ago

unybble commented 5 years ago

Describe the Feature

It would be nice if, for those on a Windows machine, there were a way to connect to a database instance using Windows Authentication. While I am not sure if the "web.config" is able to handle different connection strings, but the json formatted object has user and password attributes, which are not the format required for Windows Authentication

Suggested Solution

Is it possible to use the System.Security.Principal namespace to grab and/or validate the credentials? Or is there a way to store connection strings where user and password are not required? Instead have an optional field called "Integrated Security" which can be true or false?

Other Information

It could very well be that the Web.config is better able to handle less structured connection strings, but it was not clear to me in reading the documentation. Also, personally I am used to c# web.configs (along with the structure) -- I am unclear how a Web.config file for this application should be structured. Is it xml? What is the hierarchy? This feature request could very well be covered by this. If so, please include a sample Web.config.

justinlettau commented 5 years ago

It looks like Windows Authentication is possible, so I've added that to the roadmap.

In regards to connections in the Web.config ... a standard .NET XML config file is supported. I updated the readme with a few more details about connections in Web.config files. https://github.com/justinlettau/sql-source-control#connections

DanielOverdevest commented 5 years ago

+1 we need to migrate to AD authentication, so it would be nice to implement this feature.

blissi commented 4 years ago

+1