Lepide Help Center

Error, “Service could not enter data in database.”

Lepide Support -

Cause

  1. The user selected to configure “Service Rights” does not have sufficient privileges.
  2. This error appears when the user selected to create and access SQL Server database does not have sufficient privileges.

Solution 1

Click the pop-up message to access the wizard. If you have selected “Local System Account” to run the service and it does not have sufficient rights, select “This User” and provide the login credentials of a user with the appropriate administrative privileges. The provided user should be a member of “Administrators”, “Domain Admins”, “Group Policy Creator Owners”, “Enterprise Admins” and “Schema Admins” groups to enable File Server auditing.

If the above rights are not assigned to the user, follow the steps below:

  1. Go to “Administrative Tools.”
  2. Open “Active Directory Users and Computers.”
  3. Select “User Properties.”
  4. Go to “Member Of” à “Add Group.”
  5. Select any of the following groups as per the above requirements.
  • Administrators
  • Domain Admins
  • Group Policy Creator Owners
  • Enterprise Admins
  • Schema Admins
  1. Click “Apply” and “OK.”

Solution 2

The User creating or accessing the database for auditing logs should be assigned a “sysadmin” role in SQL Server. If you are using a SQL user, the login should have the “sysadmin” role assigned.

If you are using "Windows Authentication", a login with the currently logged on user’s name with a “sysadmin” role should exist in the SQL Server.

If such a user login does not exist, follow the steps below to create it:

  1. Open "SQL Server Management Studio."
  2. Select SQL or Windows Authentication.
  3. Enter the username and password of an SQL Server Administrator in case of SQL authentication.
  4. Click "Connect".
  5. In the left tree panel, go to "Security" → "Logins."
  6. Right click on "Logins" and select "New Login."
  7. "Login - New" wizard appears onscreen.
  8. Enter the same login name as that of currently logged-on user, with which you are running LepideAuditor Suite.
  9. Switch to "Server Roles" and select "sysAdmin."
  10. Click "OK."

If the user login exists but no such rights are assigned, perform the following steps to assign the required rights:

  1. Open "SQL Server Management Studio."
  2. Select SQL or Windows Authentication.
  3. Enter the username and password of an SQL Server Administrator in case of SQL authentication.
  4. Click "Connect."
  5. In the left tree panel, go to "Security" → "Logins."
  6. Expand "Logins" and select the required user.
  7. Right click on the user and select "Properties."
  8. Switch to "Server Roles" and select "sysAdmin."
  9. Click "OK."
  10. Go to Status page, select Grant and Enabled.
  11. Click "OK."
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk