|
Posted by Jim Kemp on March 27, 2006, 9:41 am
Please log in for more thread options OK, still having troubles.
Config is now:
Register 1: Primary IP address and RMSPrimary
Offline (local) and Offline
I can connect to both without troble in SO Admin.
I thought taht perhaps it may have been some level of network trouble so
after I configured as above and still received the same error (to my
surprise). I then created a new server on register 1 from a current backup
and configured register 2 to see that server as the primary. Still same
problem. I then switched back to the configuration Jeff specified. I tried
all I know including the old reboot but no luck. Anymore ideas will be
greatly appreciated.
"Jim Kemp" wrote:
> Thanks Jeff, I am using 2 registers and the "primary server" is located in
> another building. I may very well have had it configured wrong. My setup is
> as follows.
>
> Primary server located in different building.
> Register 1 houses Offline server.
> Register 2 uses Register 1 for Offline serrver.
>
> I will make your recomended changes now and see if it solves the problem. I
> will post my results.
>
> The only thing that doesn't make any cents is why does register 1 have this
> problem being as this is its current configuration.
>
> "Jeff" wrote:
>
> > Jim,
> >
> > Let's start at the beginning.
> >
> > Do you have 2 machines or 3?
> >
> > One machine needs to act as the database server, where the main database is.
> > It cannot _also_ have an offline database.
> >
> > The ideal scenario is that you have a office machine that is the main
> > database server and you have register machines. Each of these must have
> > MSDE/SQL Server installed on them. The register machines will have their
> > own "offline" databases on their hard drives. You create these by going
> > into SO Admin on each register and create a new, blank database.
> >
> > SO Admin | File | Connect | server name will be (local) | put in the
> > password you entered when you installed the program | OK | Database | Create
> > | name it "Offline" (no quotes) | next | click on the magnifying glass and
> > double click on the DBFiles folder | select the rmsdb file | next | finish.
> >
> > File | Configuration | Offline tab | (local) as the server name, sa for the
> > user, put your password in, database name is "Offline" (no quotes), 15 for
> > the timeout. Test it. It should test OK.
> >
> > File | Connect | put the IP on the main database server machine, main
> > database name and password
> >
> > File | Configuration | main server's IP, main database name, password and
> > test. If OK, you're good to go.
> >
> > Z or blind close and it should sync.
> >
> > Repeat at each register.
> >
> > --
> > =
> >
> > > Thanks, I have implimented all suggestions, however, the problem still
> > > persists. I have now used IP's to name the servers and again I can easily
> > > connect to both primary and Offline databases without trouble. I am still
> > > having experiencing program shutdown after creating Z and ZZ reports upon
> > > Offline database sync initialize.
> > >
> > > "Jeff" wrote:
> > >
> > >> Jim,
> > >>
> > >> Make sure to use the IP address of the main db server and not just a
> > >> name.
> > >>
> > >> Turn off any firewalls that may be running, if that works, open a hole
> > >> for
> > >> SOPosUser.exe
> > >>
> > >> --
> > >> *
> > >> Get Secure! - www.microsoft.com/security
> > >>
> > >> You must be using Outlook Express or some other type of newsgroup reader
> > >> to
> > >> see and download the file attachment. If you are not using a reader,
> > >> follow
> > >> the link below to setup Outlook Express. Click on "Open with newsreader"
> > >> under the MS Retail Management System on the right.
> > >>
> > >> http://tinyurl.com/75bgz
> > >>
> > >> **********
> > >>
> > >> Thanks Glenn, however I am using sa accounts for both primary and Offline
> > >> databases. I have created a new Offline database earlier today to see if
> > >> that
> > >> would fix the problem, however there has been no change afterwards.
> > >> Earlier
> > >> course of action: Deleted old Offline database and created new Offline
> > >> database on Register1 using most recent backup made just prior. I named
> > >> the
> > >> second database RMSMartinOffline2 and made the appropriate changes in
> > >> administrator on both registers. I can easily connect to the new database
> > >> in
> > >> Administrator and even browsed its contents and viewed some reports in it
> > >> with Manager. Then switched my connection back to the Primary database
> > >> and
> > >> logged into Operations. Once in Operations, I performed a blind closeout
> > >> and
> > >> received the same error. Help please.
> > >>
> > >> "Glenn Adams [MVP - Retail Mgmt]" wrote:
> > >>
> > >> > You need to use an 'sa' level account to log into the offline database
> > >> > and I think to the main database as well. The offline sync process
> > >> > uses
> > >> > some some advanced features of SQL Server to sync the databases and
> > >> > requires 'sa' access. Sometimes the system is set up to log in with a
> > >> > SQL Server account that has reduced permissions, which is normally good
> > >> > practice for any application, but won't work with RMS & offline
> > >> > databases.
> > >> >
> > >> > If it looks like both databases are using an sa account to connect,
> > >> > just
> > >> > create a new offline database on the register and change SO
> > >> > administrator to connect to the new database on the "Offline" tab.
> > >> > Sometimes a new DB will fix wierd sync errors...
> > >> >
> > >> >
> > >> > 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.
> > >> >
> > >> >
> > >> > Jim Kemp wrote:
> > >> > > I am having trouble after closing or creating Z and ZZ reports. I am
> > >> > > able to
> > >> > > create the reports and close the terminal, however, after the task is
> > >> > > completed, The 'Synchronize Offline Database' window appears and
> > >> > > begins
> > >> > > the
> > >> > > process. After a few moments I receive an error: Run-Time Error
> > >> > > '-2147217900
> > >> > > (80040e14)': [DBNETLIB] [ConnectionOpen (Connect()).] SQLServer Does
> > >> > > not
> > >> > > exist or access denied. Then my Store Operations terminates. I do
> > >> > > have
> > >> > > an
> > >> > > Offline database created on Register 1 in the store and I am able to
> > >> > > connect
> > >> > > to it through RMS Administrator. I am running RMS version 1.3. This
> > >> > > problem
> > >> > > has been occuring since installation.
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap