1. Home
  2. Point-Of-Sale Software
  3. Run-time error during offline DB sync

Run-time error during offline DB sync

Both registers get the same error:

--------------- Run-time error '-2147217900 (80040e14)':

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".

---------------

I am able to successfully connect to the offline DB without issue from the Admin program. Obviously, both registers connect to my live DB without issue. What is going on?

Thanks, Tom

Reply to
Terrible Tom
Loading thread data ...

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

Reply to
Ryan

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:

Reply to
Eugen

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

Reply to
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

Reply to
davidschultz45

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.