Verifying the Authentication Mode for a SQL Server

The AVEVA Historian is compatible with either Windows authentication mode or mixed mode (Windows authentication and SQL Server authentication).

Important: SQL Server authentication is provided for backward compatibility only. For improved security, we recommend that you use Windows authentication.

To verify the authentication mode

1. Start SQL Server Management Studio.

2. In the console tree, right-click the SQL Server.

3. In the shortcut menu that appears, click Properties. The SQL Server Properties dialog box appears.

4. Click the Security tab.

   

5. Verify the authentication mode.

   The SQL Server and Windows option corresponds to mixed mode authentication. If you change the authentication mode, you must stop and restart the SQL Server. Also, modification tracking in the historian, if enabled, will not occur until you restart the historian.

   The AVEVA Historian services log on to SQL Server using the ArchestrA user account, which is a Windows account. For information, see Default Windows User Account for AVEVA Historian Services.

6. Click OK.