Failed to login by user:

Netwrix Auditor SQL Databases
6.5 and older
Copy Article URL Copied

You receive the error message “Failed to login by user: <Netwrix service account>”.

The Netwrix service account does not have access to login/upload data to the SQL database.

Login to SQL Server Management Studio for your SQL instance and perform the following steps:

1. Select Security
2. Select New Login

User-added image

1. Enter the netwrix service account into the Login name field
2. Select Server Roles

User-added image

Check sysadmin role to give full access to the netwrix service account

User-added image

Go Up