How to use a domain account to log audit data into SQL Server

Version Affected:  All

Description:  

When configuring the SQL Reporting database, it is possible to use a domain account instead of specifying SQL credentials by selecting Integrated Security.  

However, this doesn't allow you to specify the Windows Creds in the Admin Console

Cause:  

Once you enable Integrated Security, we'll use the AppPool Identity.

Resolution:  

1. Ensure the IdP is joined to the domain to utilize a domain account.
 
2. In IIS, set the application pool Identity for both the .NET v4.5 and SecureAuth0 app pools to use the  domain account; and set Load User Profile to True.
 
3. Make the Domain account is a member of the local administrators group of the SecureAuth IdP server(s). (login as batch right required)
 
 

SecureAuth Knowledge Base Articles provide information based on specific use cases and may not apply to all appliances or configurations. Be advised that these instructions could cause harm to the environment if not followed correctly or if they do not apply to the current use case.

Customers are responsible for their own due diligence prior to utilizing this information and agree that SecureAuth is not liable for any issues caused by misconfiguration directly or indirectly related to SecureAuth products.