Skip to main content

Failed to login by user: <netwrix service account>

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.

Resolution​

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

  1. Select Security
  2. Select New Login

Screenshot: SQL Server Management Studio - Select Security > New Login

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

Screenshot: Enter Netwrix service account and select Server Roles

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

Screenshot: Check sysadmin role for the service account