---
id: AA-00660
title: "Configuring SQL Express for Mixed Mode Authentication"
url: http://netaphor.com/kb/AA-00660/configuring-sql-express-for-mixed-mode-authentication
product: "SiteAudit OnSite"
type: "Troubleshooting"
updated: 2015-05-13
access: public
---


# Configuring SQL Express for Mixed Mode Authentication

This article describes how to enable SQL Express Mixed Mode Authentication.

SQL Express is installed silently when using the prerequisites downloaded from Netaphor™, which installs the application for Windows Authentication mode only. However, it may be desired to use SQL authentication and allow multiple users to log onto the Windows machine to manage, audit, or create reports using SiteAudit.

### Enable Mixed Mode Authentication

To enable Mixed Mode Authentication:

1. Stop monitoring.
2. Open the **Diagnostics **\> **SQL Query** tool.
3. Copy the query below and paste it into the Query window:
4. **EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\\Microsoft\\MSSQLServer\\MSSQLServer', N'LoginMode', REG_DWORD, 2**
5. Click the **Execute **button to run the query
6. Select the **Messages **tab to confirm the query succeeded

![](http://netaphor.com/kb/media/AA-00660/query.png)

1. Close the SQL Query tool.
2. Close the SiteAudit Viewer.
3. Open the Services and restart the SQL Server (SQLExpress) service:

![](http://netaphor.com/kb/media/AA-00660/restartservice.png)

1. Open the SiteAudit Viewer.
2. Connect to the SiteAudit database using SQL Authentication and the credentials of a SQL user who is an owner (dbo) of the SiteAudit database. To learn more about creating new users and connecting to the SiteAudit database using new credentials, refer to the **[Connecting to SiteAudit Database](http://netaphor.com/kb/AA-00512) **article.