|
Posted by JD on April 9, 2007, 9:20 pm
Please log in for more thread options 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
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap