# TagHistoryDatasourceSink Warning and VPN Connection

**URL:** <https://forum.inductiveautomation.com/t/taghistorydatasourcesink-warning-and-vpn-connection/29562>\
**Category:** Ignition\
**Created:** [October 31, 2019, 3:40pm UTC](https://forum.inductiveautomation.com/t/taghistorydatasourcesink-warning-and-vpn-connection/29562 "2019-10-31T15:40:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\
**Post date:** [October 31, 2019, 3:40pm UTC](https://forum.inductiveautomation.com/t/taghistorydatasourcesink-warning-and-vpn-connection/29562/1 "2019-10-31T15:40:59Z")

</div>

Just wanted to document an issue I found while trying to have a remote site connect and store data to a central MS SQL DB over VPN. The issue I saw was that the Store and Forward engine was unable to create all the tables in the database. Only sqlth\_drv, sce, scinfo and te got created. But sqlth\_partitions and the corresponding \_data\_x\_year\_month tables were never getting created. The log files were riddled with errors and warnings such as:  
TagHistoryDatasourceSink - There is a problem checking the tag history database tables during initialization of the store and forward engine which could prevent tag history data from being forwarded properly. Trying again in 60 seconds.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/64b01b6bc7fd0f9d41cca8846872aa823b621d00.png)

and DatasourceForwardTransaction - Error forwarding data

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fa3aa39233d6dafc2ed7bbe8cf20840a34d69b9d.png)

Turns out that I was making this connection to the database over an IPSec VPN connection. After hours of struggling…I decided to change to SSL VPN connection. After that, all warnings and errors are gone. I don’t know the inner workings of IPSec or SSL VPN, but something was blocking specific create table instructions (if that is even possible).

The other issue was that my Remote Tag Provider setup on the main server was unable to pull the tags from the remote site (connection via Gateway Network). Again, once I changed the VPN connection type from IPSec to SLL, problem solved.

Hope this helps someone else. Or if anyone knows why SSL worked and IPSec didn’t, I’m all ears.
