Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Error: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception



Issue

When Jet Essentials is using a direct connection to NAV’s SQL database, a non-admin user can receive the following error:

"An unexpected error has occurred: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception...



Resolution

Non-admin user accounts need to be assigned to the "Impersonate a client after authentication" security policy role to allow Jet Essentials to access data directly from a SQL database.

Here are the steps that a LOCAL ADMINISTRATOR will need to follow to add the non-admin user to this role:

  1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
  2. Expand Local Policies, and then click User Rights Assignment.
  3. In the right pane, double-click Impersonate a client after authentication.
  4. In the Local Security Policy Setting dialog box, click Add User or Group.
  5. In the Select Users or Group dialog box, find the user account that you want to add, click Add, and then click OK.
  6. Click OK.
  7. Reboot the system and try the steps to reproduce the problem.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments