INSERT permission denied on 'tblEventLog'

Problem:

Exception Type: System.Data.SqlClient.SqlExceptionhttp://www.vtoxford.org/enicq/enicq5/documents/eNICQ5SystemAdministratorsGuide.pdfhttp://www.vtoxford.org/enicq/enicq5/documents/eNICQ5SystemAdministratorsGuide.pdf

An unhandled exception occurred, and the application is terminating.

The exception was: The INSERT permission was denied on the object 'tblEventLog', database 'enicqdb', schema 'dbo'.

Solution:

This is a common error when necessary permissions have not been granted to the eNICQ database. Contact your database administrator for help resolving this problem. Please refer to Chapter 1 of the eNICQ 5 System Administrator's Guide for information on setting up database authentication.

http://www.vtoxford.org/enicq/enicq5/documents/eNICQ5SystemAdministratorsGuide.pdf

All accounts and groups connecting to the database should be given the 'enicqdbuser' and 'public' roles.

Have more questions? Submit a request

Comments