Synchronization problem

Posted by Glenn Adams [MVP - Retail Mgmt on April 10, 2007, 9:34 am

Please log in for more thread options

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 Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

JD wrote:

> 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:

>> 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 Consulting

>> http://www.tibercreek.com

>> glenn@tibercreek.com

>> ----------------------------------------------

>> Please DO NOT respond to me directly but post all responses here in the

>> newsgroup so that all can share the information.

>> JD wrote:

>>> 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:

>>>

>>>> hi JD, make sure when you configure the offline db correctly go to

>>>> configuration and then in offline tab see and check the server name you can

>>>> put [local] (as you state in your messgae) then enter the db name, correct

>>>> user id and password. also increate the timeout to 90 o something more. try

>>>> test the connection. if it works then go and perform the z-out. see if this

>>>> solve the issue.

>>>>

>>>> "JD" wrote:

>>>>

>>>>> Hi,

>>>>>

>>>>> I just created an offline database on a client machine. Opened POS and

>>>>> printed Z report. The computer started with the sync. process but, after

few

>>>>> moments returned with an error message "Login timeout expired". I have

looked

>>>>> up knowledgebase but could not find any help.

>>>>>

>>>>> I would appreciate if anyone out there can point me in the right directin.

>>>>>

>>>>> Regards

>>>>> JD

Posted by JD on April 10, 2007, 4:32 pm

Please log in for more thread options

Hi Glen,

I gave the register and the server static IP addresses. Opened Admin in
register and replaced the server and the register name with their IP. I was
able to connect register(local db) DB successfully but, had trouble with
connecting to Server. The error message I got was: SQL Server does not exist
or access denied ConnetionOpen (Connect())

"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 Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information.

> JD wrote:

> > 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.

> > am still getting the same exact message. Please help!

> >

> > JD

> >

> > "Glenn Adams [MVP - Retail Mgmt]" 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 Consulting

> >> http://www.tibercreek.com

> >> glenn@tibercreek.com

> >> ----------------------------------------------

> >> Please DO NOT respond to me directly but post all responses here in the

> >> newsgroup so that all can share the information.

> >>

> >> JD wrote:

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

> >>> 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:

> >>>

> >>>> hi JD, make sure when you configure the offline db correctly go to

> >>>> configuration and then in offline tab see and check the server name you

can

> >>>> put [local] (as you state in your messgae) then enter the db name,

correct

> >>>> user id and password. also increate the timeout to 90 o something more.

try

> >>>> test the connection. if it works then go and perform the z-out. see if

this

> >>>> solve the issue.

> >>>>

> >>>> "JD" wrote:

> >>>>

> >>>>> Hi,

> >>>>>

> >>>>> I just created an offline database on a client machine. Opened POS and

> >>>>> printed Z report. The computer started with the sync. process but, after

few

> >>>>> moments returned with an error message "Login timeout expired". I have

looked

> >>>>> up knowledgebase but could not find any help.

> >>>>>

> >>>>> I would appreciate if anyone out there can point me in the right

directin.

> >>>>>

> >>>>> Regards

> >>>>> JD

Posted by Glenn Adams [MVP - Retail Mgmt on April 10, 2007, 6:06 pm

Please log in for more thread options

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 Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

JD wrote:

> Hi Glen,

> I gave the register and the server static IP addresses. Opened Admin in

> register and replaced the server and the register name with their IP. I was

> able to connect register(local db) DB successfully but, had trouble with

> connecting to Server. The error message I got was: SQL Server does not exist

> or access denied ConnetionOpen (Connect())

> "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 Consulting

>> http://www.tibercreek.com

>> glenn@tibercreek.com

>> ----------------------------------------------

>> Please DO NOT respond to me directly but post all responses here in the

>> newsgroup so that all can share the information.

>> JD wrote:

>>> 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.

>>> am still getting the same exact message. Please help!

>>>

>>> JD

>>>

>>> "Glenn Adams [MVP - Retail Mgmt]" 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 Consulting

>>>> http://www.tibercreek.com

>>>> glenn@tibercreek.com

>>>> ----------------------------------------------

>>>> Please DO NOT respond to me directly but post all responses here in the

>>>> newsgroup so that all can share the information.

>>>>

>>>> JD wrote:

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

>>>>> 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:

>>>>>

>>>>>> hi JD, make sure when you configure the offline db correctly go to

>>>>>> configuration and then in offline tab see and check the server name you

can

>>>>>> put [local] (as you state in your messgae) then enter the db name,

correct

>>>>>> user id and password. also increate the timeout to 90 o something more.

try

>>>>>> test the connection. if it works then go and perform the z-out. see if

this

>>>>>> solve the issue.

>>>>>>

>>>>>> "JD" wrote:

>>>>>>

>>>>>>> Hi,

>>>>>>>

>>>>>>> I just created an offline database on a client machine. Opened POS and

>>>>>>> printed Z report. The computer started with the sync. process but, after

few

>>>>>>> moments returned with an error message "Login timeout expired". I have

looked

>>>>>>> up knowledgebase but could not find any help.

>>>>>>>

>>>>>>> I would appreciate if anyone out there can point me in the right

directin.

>>>>>>>

>>>>>>> Regards

>>>>>>> JD

Posted by JD on April 10, 2007, 7:52 pm

Please log in for more thread options

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:

> 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 Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information.

> JD wrote:

> > Hi Glen,

> >

> > I gave the register and the server static IP addresses. Opened Admin in

> > register and replaced the server and the register name with their IP. I was

> > able to connect register(local db) DB successfully but, had trouble with

> > connecting to Server. The error message I got was: SQL Server does not exist

> > or access denied ConnetionOpen (Connect())

> >

> > "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 Consulting

> >> http://www.tibercreek.com

> >> glenn@tibercreek.com

> >> ----------------------------------------------

> >> Please DO NOT respond to me directly but post all responses here in the

> >> newsgroup so that all can share the information.

> >>

> >> JD wrote:

> >>> 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:

> >>>

> >>>> 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 Consulting

> >>>> http://www.tibercreek.com

> >>>> glenn@tibercreek.com

> >>>> ----------------------------------------------

> >>>> Please DO NOT respond to me directly but post all responses here in the

> >>>> newsgroup so that all can share the information.

> >>>>

> >>>> JD wrote:

> >>>>> 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:

> >>>>>

> >>>>>> hi JD, make sure when you configure the offline db correctly go to

> >>>>>> configuration and then in offline tab see and check the server name you

can

> >>>>>> put [local] (as you state in your messgae) then enter the db name,

correct

> >>>>>> user id and password. also increate the timeout to 90 o something more.

try

> >>>>>> test the connection. if it works then go and perform the z-out. see if

this

> >>>>>> solve the issue.

> >>>>>>

> >>>>>> "JD" wrote:

> >>>>>>

> >>>>>>> Hi,

> >>>>>>>

> >>>>>>> I just created an offline database on a client machine. Opened POS and

> >>>>>>> printed Z report. The computer started with the sync. process but,

after few

> >>>>>>> moments returned with an error message "Login timeout expired". I have

looked

> >>>>>>> up knowledgebase but could not find any help.

> >>>>>>>

> >>>>>>> I would appreciate if anyone out there can point me in the right

directin.

> >>>>>>>

> >>>>>>> Regards

> >>>>>>> JD

Posted by Glenn Adams [MVP - Retail Mgmt on April 11, 2007, 9:55 am

Please log in for more thread options

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 Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

JD wrote:

> 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:

>> 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 Consulting

>> http://www.tibercreek.com

>> glenn@tibercreek.com

>> ----------------------------------------------

>> Please DO NOT respond to me directly but post all responses here in the

>> newsgroup so that all can share the information.

>> JD wrote:

>>> Hi Glen,

>>>

>>> I gave the register and the server static IP addresses. Opened Admin in

>>> register and replaced the server and the register name with their IP. I was

>>> able to connect register(local db) DB successfully but, had trouble with

>>> connecting to Server. The error message I got was: SQL Server does not exist

>>> or access denied ConnetionOpen (Connect())

>>>

>>> "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 Consulting

>>>> http://www.tibercreek.com

>>>> glenn@tibercreek.com

>>>> ----------------------------------------------

>>>> Please DO NOT respond to me directly but post all responses here in the

>>>> newsgroup so that all can share the information.

>>>>

>>>> JD wrote:

>>>>> 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:

>>>>>

>>>>>> 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 Consulting

>>>>>> http://www.tibercreek.com

>>>>>> glenn@tibercreek.com

>>>>>> ----------------------------------------------

>>>>>> Please DO NOT respond to me directly but post all responses here in the

>>>>>> newsgroup so that all can share the information.

>>>>>>

>>>>>> JD wrote:

>>>>>>> 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:

>>>>>>>

>>>>>>>> hi JD, make sure when you configure the offline db correctly go to

>>>>>>>> configuration and then in offline tab see and check the server name you

can

>>>>>>>> put [local] (as you state in your messgae) then enter the db name,

correct

>>>>>>>> user id and password. also increate the timeout to 90 o something more.

try

>>>>>>>> test the connection. if it works then go and perform the z-out. see if

this

>>>>>>>> solve the issue.

>>>>>>>>

>>>>>>>> "JD" wrote:

>>>>>>>>

>>>>>>>>> Hi,

>>>>>>>>>

>>>>>>>>> I just created an offline database on a client machine. Opened POS and

>>>>>>>>> printed Z report. The computer started with the sync. process but,

after few

>>>>>>>>> moments returned with an error message "Login timeout expired". I have

looked

>>>>>>>>> up knowledgebase but could not find any help.

>>>>>>>>>

>>>>>>>>> I would appreciate if anyone out there can point me in the right

directin.

>>>>>>>>>

>>>>>>>>> Regards

>>>>>>>>> JD