# Please, Can you help me Edge Sync Services with SQL server

**URL:** <https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [October 26, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020 "2020-10-26T15:07:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![duchung821](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@duchung821](https://forum.inductiveautomation.com/u/duchung821)\
**Post date:** [October 26, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020/1 "2020-10-26T15:07:47Z")

</div>

![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/8/c834ab50312131506c838443c495c3dd7b2e276b.png)

I cannot synchronize data with SQL, I have declared it as shown. In which “MS\_SQL” is the database which is connected from the gateway server

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 26, 2020, 3:37pm UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020/2 "2020-10-26T15:37:15Z")

</div>

That’s not how Edge’s history sync works. You need to target a second Ignition gateway, that you’re connected to over the gateway area network. Edge _cannot_ directly store data into a database, by design.

---

<div class="post-metadata">

**Author:** ![duchung821](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@duchung821](https://forum.inductiveautomation.com/u/duchung821)\
**Post date:** [October 27, 2020, 3:21am UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020/3 "2020-10-27T03:21:45Z")

</div>

yes. 192.168.0.33 is IP address Ignition gateway, “MS\_SQL” is Remote History Provider Name  
I don’t understand how it should be configured properly.  
please, can you help me.  
thank you verry much!

 ![fault](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/a/4a3f1a6c8f3a5be9cefeceb0d80c706e1f1e71ea.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 27, 2020, 3:49pm UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020/4 "2020-10-27T15:49:17Z")

</div>

You need to make a gateway network connection to your other gateway (Configure -\> Connections -\> Gateway Network) - _that’s_ where you will enter the remote gateway’s IP. Once you’ve done that, you’ll enter that gateway’s **name** (not it’s IP address) in the `Remote Gateway Name` field.  
You will likely also need to configure ‘Service Security’ on the remote gateway to allow the edge gateway to store history using its history provider.

[https://docs.inductiveautomation.com/display/DOC80/Gateway+Network#GatewayNetwork-SettingUpaGatewayNetworkConnection](https://docs.inductiveautomation.com/display/DOC80/Gateway+Network#GatewayNetwork-SettingUpaGatewayNetworkConnection)  
[https://docs.inductiveautomation.com/display/DOC80/Security+Zones#SecurityZones-ServiceSecurity](https://docs.inductiveautomation.com/display/DOC80/Security+Zones#SecurityZones-ServiceSecurity)  
[https://docs.inductiveautomation.com/display/DOC80/Edge+Sync+Services#EdgeSyncServices-DataSynchronization](https://docs.inductiveautomation.com/display/DOC80/Edge+Sync+Services#EdgeSyncServices-DataSynchronization)

---

<div class="post-metadata">

**Author:** ![duchung821](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@duchung821](https://forum.inductiveautomation.com/u/duchung821)\
**Post date:** [October 28, 2020, 2:16am UTC](https://forum.inductiveautomation.com/t/please-can-you-help-me-edge-sync-services-with-sql-server/40020/5 "2020-10-28T02:16:25Z")

</div>

thanks you for your support. I did it
