Synchronize Offline failed

Open Store Operation Administrator into your 2nd pc..

File | Configuration

Database - Try connection

Offline - Try connection

It can an error to open offline database... but in MSDN they are more messages with your error code..

sorry antonio

This sounds ridiculous, but you need to configure the firewall on the second PC so that it can connect to it's own database. I've had this problem with the WinXP SP2 firewall and with Norton Internet Security - I suspect McAfee will do the same thing, but I avoid it like the plague...

You should be able to use the same steps you used to open the firewall on register 1.

Also, make sure that you use the same credentials (SQL User ID & Password) on the Offline database as you use on the main one.

Antonio, thanks for your reply. Yes, at File | Configuration, it can connect both the main and the Offline databases from the 2nd PC without the error message.

Regards, Jas> >

Glenn, thanks for your help. Both PC are WinXP SP2 in a workgroup. What settings in firewall or Norton could cause the problem? By the way, both PC have the same user id and password.

Regards, Jason

"Glenn Adams [MVP - Retail Mgmt]" wrote:

try with this example..

configure the POS of first pc to work with offline of 2nd pc.. and close batch from 1st pos.. It's possible that is only a problem of DTC (this error isn't new.. but now I not remember the solution..)

antonio

Just turn off the firewall temporarily and see if the off line database starts syncing. If it does, enter an exception in the firewall to open the SQL Server Port (1433 is the default). You must have opened the firewall on the main register, or register 2 would not be connecting at all - the same rules used there should also work on register 2.

If turning off the firewall doesn't fix the problem, you'll have to look elsewhere for a solution - firewall and user credentials are the only issues that I've run into - you may want to verify that the SQL Server Service is starting at boot up. You may have to turn the firewall off then reboot - sometimes turning it off doesn't seem to 'take'...