Run-time error during offline DB sync

Tom, Do you have a lot of customers or items in your database. I mean extreme amounts like more than 400,000?

TT,

Make sure the logged in user has registry access to the RMS keys.

Note For proper synchronization to occur, the Windows user should be one of the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations

Specifically, the nonadministrator user should have full control permission on the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\POSUser

This situation will allow nonadministrator users to synchronize back from RMS Terminal Offline Mode.

To allow RMS Terminal Offline Mode to function correctly when you run POS from a nonadministrator Windows user account, follow these steps:

1. While you are logged on to Windows under an administrator account, open the registry editor. To do this, click Start, click Run, type REGEDIT, and then click OK.

1. Locate and then right-click the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\POSUser

1. Click Permissions, and then click Advanced.

1. Locate or create the permissions entry or entries that apply to the nonadministrator account or accounts that will run POS in offline mode, click the entry, and then click Edit.

2. Under the Allow column for this user, click to select the Full Control checkbox.

1. In the dialog boxes, click OK to apply the settings.

Regards,

Jeff

Hi Terrible Tom,

Did you ever find an answer to this problem. I have a site with the same issue. Administrator connects to both the live and offline databases fine. I can alternate between the two and the POS runs fine.

I get [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exists or access denied.

I'm us> Both registers get the same error:

I had an issue getting backup database to sync and had to set a port 1433 exception in the firewall to get it to work.

Marc

I am having the same problem on multiple machines as described in the first post by Terrible Tom. I have tried setting the Port 1433 and checked the permissions in the registry as suggested also, but neither had any effect on sychronizing the offline database.

Any other suggestions would be much appreciated!

Thanks > I had an issue getting backup database to sync and had to set a port 1433