Using the KampData TaxEngine on a server that is not attached to the Microsoft Dynamics GP SQL Server.
For security or other reasons, your Internet or Web Server may not have a direct connection to the SQL Server being used by Microsoft Dynamics GP In this case you will need to replicate the databases and certain tables on the Web Server to enable the use of the KampData TaxEngine on that server.
There are various complications related to manually creating databases and using the SQL Server Import and Export Wizard to move data into those databases. Primary complications include proper creation of the tables and all of their indexes/keys, as well as creating DYNGRP and assigning rights. To avoid these problems, we recommend using one of the following approaches.
Once the tables are properly created on the web server with rights properly assigned to DYNGRP, future updates could be handled using the SQL Server Import and Export Wizard.
If Microsoft Dynamics GP has not been installed on the Web Server, you will need to use the SQL Passwords Only edition of the KampData TaxEngine.