I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection.  I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval and then editing the restrictions text file (C:\Sage100Con\Settings\[DBname]_RestrictedApplications.xml).  That works great.  From within Crystal Reports, I go to Set Data Source Location and Add a Connection, select Microsoft and our version of SQL Server and ODBC, enter the same username and password and select the ODBC connection, I always get this error in Crystal Reports:  Logon Error:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master' .  In the Event Viewer Application log on the SQL server are these two error messages: 1). Error: 50000 Severity: 20 State: 1 SAGE ERROR 50004: The application '' is not allowed to connect to this server. Host:    User: crystal_reports; 2). Logon failed for login 'crystal_reports' due to trigger execution. [CLIENT: (IP Address of client) ]

Now if I try this with a Sage/SQL Server admin credentials, it works.  But obviously I don't want to do that as a permanent solution.

So the Application logs aren't not showing me the application name nor the Host, which I think is unusual as it does it for other applications that try to connect.  Is that something I need to set under the 'Custom Parameters' tab in Crystal Reports?

Thanks for anyone's help!