Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

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



When user a 'Dynamics NAV 2013 and later (SQL Server)' data source in the Jet Excel Add-In, 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...



Non-admin user accounts need to be assigned to the "Impersonate a client after authentication" security policy role to allow the Jet Excel Add-In 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