How to Verify NT AUTHORITY Permissions in SQL Server

In some cases, GuardPoint10 may require the NT AUTHORITY login to have the correct SQL permissions to allow the services to access the database properly.

This guide explains how to verify and assign the correct permissions using SQL Server Management Studio (SSMS).

1. Connect to the SQL Server

1. Open SQL Server Management Studio (SSMS).

2. Connect to the SQL Server instance that hosts your GuardPoint10 database.

2. Locate the NT AUTHORITY Login

1. In the Object Explorer, expand:

Security
   └ Logins

2. Locate NT AUTHORITY in the list of logins.

3. Double-click the NT AUTHORITY login to open its properties.

3. Assign the Required Server Role

1. Go to the Server Roles tab.

2. Tick the following role:

✔ sysadmin

This grants the required server-level permissions for the GuardPoint10 services to interact with SQL.

4. Configure Database Permissions

1. Navigate to the User Mapping tab.

2. Select the GuardPoint10 databases:

✔ GuardPoint10 database
✔ Journal database

3. In the Database role membership section, select:

✔ db_owner

This ensures the services have full access to the GuardPoint10 databases.

5. Apply the Changes

Click OK to save the configuration.

The NT AUTHORITY login is now correctly configured.