Offline Synchronize problem

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Offline Synchronize problem Jim Kemp 03-21-2006  Re: Offline Synchronize problem Glenn Adams [MVP - Retail... 03-21-2006  Re: Offline Synchronize problem Glenn Adams [MVP - Retail... 03-21-2006  Re: Offline Synchronize problem Jim Kemp 03-21-2006  Re: Offline Synchronize problem Jeff 03-21-2006  Re: Offline Synchronize problem Jim Kemp 03-22-2006  Re: Offline Synchronize problem Jeff 03-24-2006  Re: Offline Synchronize problem Jim Kemp 03-24-2006  Re: Offline Synchronize problem Jim Kemp 03-27-2006  Re: Offline Synchronize problem Jeff 03-28-2006  RE: Offline Synchronize problem Keith 04-24-2006  RE: Offline Synchronize problem salinden 06-05-2006  Re: Offline Synchronize problem Jeff 06-06-2006  Re: Offline Synchronize problem salinden 06-06-2006  Re: Offline Synchronize problem Jeff 06-06-2006
Posted by Jim Kemp on March 21, 2006, 4:17 pm Please log in for more thread options 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. Posted by Glenn Adams [MVP - Retail Mgmt on March 21, 2006, 5:20 pm Please log in for more thread options 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. Posted by Glenn Adams [MVP - Retail Mgmt on March 21, 2006, 5:21 pm Please log in for more thread options 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. Posted by Jim Kemp on March 21, 2006, 7:05 pm Please log in for more thread options 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. > Posted by Jeff on March 21, 2006, 8:58 pm Please log in for more thread options 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. > Similar Threads Posted Offline Problem May 1, 2008, 9:55 am offline sync problem December 18, 2005, 10:25 pm Offline Z report problem. December 21, 2007, 7:31 pm offline inventory sync problem August 8, 2006, 10:38 am Transfer out from Offline Inventory Problem March 9, 2008, 4:43 pm Offline Inventory - Transfer Out Search Problem December 18, 2006, 1:39 pm Sync problem-Sale missing in Offline mode January 7, 2008, 2:34 am Synchronize HQ data from SO October 15, 2007, 1:20 pm re synchronize the HQ database March 2, 2009, 12:11 pm Synchronize field length in RMS and GP July 17, 2007, 6:06 pm