Windows authentication on your database with Active Directory

One of the benefits of Active Directory is that you can have end to end authentication from multiple software systems, on DBxtra, this means that you can use Windows Authentication in your database, if there is support for it, to limit the information the user sees from the web. To enable this feature do as follows:

1.- Be sure that Single Sign On is enabled and working on the Report Web Service, for more information you can read here: https://www.documentation.dbxtra.com/kb/dbxtra-report-designer/user-security/active-directory-synchronization/single-sign-on-in-the-report-web-service/

2.- Open the Internet Information Services Manager (Control Panel->Administrative Tools->Internet Information Services Manager)

3.- Go to the virtual directory used by DBxtra (DBxtra.NET by default)

4.- Open the authentication protocols page (IIS->Authentication)

5.- Enable ASP.NET Impersonation (Actions Pane->Enable)

6.- Go to Application Pools and recycle the App Pool used by DBxtra (DBxtra .NET App Pool by default)

7.- Go to Sites and restart the Web Site where DBxtra is hosted on.

Note: Be sure that your database supports Windows Authentication and that you have the proper permissions set up for this to work properly; currently, only SQL Server and Oracle have support for Windows Authentication on DBxtra.