Visual Studio Just in Time debugger pops up when running addressing

Are you getting a message along the lines of "An unhandled Exception ...occurred in addressing.exe" ?  

 

This normally indicates a permissions issue and can affect both addressing and NCOA.

The addressing and NCOA run outside of SQL Server, so that if they crash they won't bring down your SQL instance with it.  The downside of this is permissions requirements for the addressing may cause it to not work out of the box.

 

This error happens most often on production environments, where it is more locked down that standard dev environments.

Normally the quickest and easiest fix for this is to run services.msc and locate the 'matchIT SQL Service' ,then right click on it and goto properties, and set the service to run as a higher permission domain account that has read/write access on the server for any temp files created by the addressing/ncoa as well as datareader/datawriter/ddladmin permissions on any databases you're working with. Ensure you restart the service after changing the login.

Was this article helpful?
0 out of 0 found this helpful

have a question or not finding what you're looking for?

Submit a ticket to get some help