Community
Showing results for 
Search instead for 
Do you mean 
Reply

Failed to setup local sync entity. Datastore is inaccessible - internet sync 2012 SP1

New Member
Posts: 8
Country: United_Kingdom

Failed to setup local sync entity. Datastore is inaccessible - internet sync 2012 SP1

Dear ACT Support Team,

 

Testing Network sync is fine and works well.

Testing Internet sync can be frustrating.

 

I have Vista and Windows 7 laptops users with local administative rights and running Sage ACT! 2012 Premium with Service Pack 1.  The remote database is stored in c:\actdb

The network server which is Microsoft Windows Server 2008 R2 and the same version of Sage ACT! 2012.

 

My testing thus far is I know the laptop can communicate with the Server over the internet as it can resolve and connect to http:\\server.domain.com\ActInternetSync

I have tested this by renaming on the server syncConfigFile.xml to syncConfigFile.xml.old in folder C:\ProgramData\ACT\ACT Data and restart IIS (which should be pointed out that any change to web.config requires IIS to be restarted for the changes to be recognised).

The laptop displays a message of Unable to acquire Sync Server object. Server Error Description: Failed to find main database [\\Server\ACTDB] for sync.

 

If I rename syncConfigFile.xml.old back to syncConfigFile.xml and restart IIS

The laptop displays a message of Unable to acquire Sync Server object. Server Error Description: Failed to setup local sync entity. Datastore is inaccessible.

So proving that the laptop is able to communicate to the server over the internet.

 

My question is what do I have to do to get ACT to access the Datastore on laptop for internet sync.

The security permissions of the act-db database files folder and pad file is:

SYSTEM Full control, Local Administrators group Full Control.

All domain users are local administrators on the laptops.

SYSTEM is not listed on the security permissions of the ALF or ADF

Please advise what permissions internet sync requires on Sage ACT 2012 SP1 on Vista / Windows 7

Kind Regards

Paul Holoway

 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Failed to setup local sync entity. Datastore is inaccessible - internet sync 2012 SP1

Hello Paul,
See if the suggestions in the following Knowledgebase article help resolve the issue:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2333...

You can also try disabling User Account Control on the server. As an alternative to Internet Sync, you may want to consider using Network Sync over the Internet using port forwarding - this will take IIS out of the equation. See this KB article for more information:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1753...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Elite Contributor
Posts: 105
Country: New Zealand

Re: Failed to setup local sync entity. Datastore is inaccessible - internet sync 2012 SP1

I had this issue after upgrading to Windows 8.1

The solution was http://kb.swiftpage.com/app/answers/detail/a_id/23332/kw/failed%20to%20setup%20local%20sync%20identi...

Stephen Buckland
stephenbuckland@gmail.com