Synchronization problem

Hi Akbar,

First, let me thank you for your response. I tried your recommendations but, unfortunately it has not resolved the problem. Let me explain exactly how I configured and the details of the problem:

1. Created a database on the local machine from rmsdb.bck and named it localdb
2. In Store Administrator under configuration did the following:

Primary DB Server:

Server name: Primary server name user name: sa Password: *** Database: Primary database name Connection timeout: 15

When I click on "test database", I get database connection successful.

Offline DB Server Server Name: (local) User name: sa Password:*** Database: localdb Connection timeout: 90

When I click on "test database", I get database connection successful.

Now I opened POS and I printed a Z report. After printing, the message shows up saying: Synchronizing Offline database: Synchronizing table: Alias

Then after a few moments I get a message:

Run-time error "-2147217900 (80040e14)": OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired"

BTW, I am running RMS 2.0.

Regards JD

"Akber Alwani" wrote:

You have either a firewall issue or more likely the local (register) copy of SQL 2005 Express is not configured to accept incoming connections.

Open the SQL Server Surface Area configuration tool Click Configuration for services and connections Make sure that Incoming connections are allowed - I would suggest allowing both TCP/IP and Named Pipes, but either one should work. Also make sure the SQL Browser Service is set to auto-start.

Now open Configuration for Features Make sure that the OPENROWSET functionality is enabled - it should be the first feature option displayed.

If you still have trouble with the Z-Report & Sync after these changes, turn off any software firewalls on the register - if you have a third party firewall, make sure you check the Windows XP SP2 firewall as well as the 3rd party; sometimes they will both be active.

During the offline sync, the main database server makes a connection to the local database and 'pushes' changes into it. This requires the offline server to accept incoming connections.

Hope that helps.

Glenn Adams Tiber Creek C> Hi Akbar,

Hi Glen,

I followed your instructions, and in addition to it made Microsoft SQL server a shared folder and allowed network users to make changes on the it. I am still getting the same exact message. Please help!

JD

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

Try giving both the server and the register static IP addresses and using the IP as the Server Name. That (Null) in the connection message looks like the offline database server is not being found as (local).

Glenn Adams Tiber Creek C> Hi Glen,

Hi Glen,

I gave the register and the server static IP addresses. > Try giving both the server and the register static IP addresses and

You have either mistyped the Server IP Address or the server is only allowing Named Pipes connections - check the surface area configuration tool on the server.

Glenn Adams Tiber Creek C> Hi Glen,

Hi Glenn,

I made sure the IP address is correct and in surface area configuration for remote connections are set to use both TCP/IP and named pipes. Still getting the same error when putting IP of the Server at the register.

Any other suggestions??

Regards JD

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

I'd try turning off the firewalls on both sides - it may be open for named pipes but not TCP/IP. Other than that, I'm out...

Glenn Adams Tiber Creek C> Hi Glenn,