yorek / ssis-dashboard

HTML5 SQL Server Integration Services Dashboard
http://ssis-dashboard.azurewebsites.net/
Apache License 2.0
259 stars 104 forks source link

Active Directory Authentication? #35

Open neil-bowers opened 5 years ago

neil-bowers commented 5 years ago

I love this dashboard - so does my leadership.

However, we have a requirement to secure these things behind Active Directory and restrict who can view them. Preferably we'd authorized based on an AD group that all our DBA's and other relevant folks are members of, and anyone else would just get a restricted page or re-directed to our service portal.

However, since this runs using Flask, is there actually a way to implement AD authentication?

yorek commented 5 years ago

Hi Neil, you should be able to implement AD authentication by running flask using IIS-FastCGI: https://medium.com/@bilalbayasut/deploying-python-web-app-flask-in-windows-server-iis-using-fastcgi-6c1873ae0ad8