Hi,
I have been using Microsft RMS for Past year and a half for operations at my small speciality grocery store. I have had a fair smooth experience with RMS during this time, aside from a few lockups and crashes every now and then. Couple of days ago, my system crashed in a middle of a transaction, and immdiately restarted. Both Manager and POS modules were running on the computer at the time. Cashier notified the the Supervisor about the hold up in the processing of the transaction. Supervisor mistakenly assuming that the system had froze manually restarted the system while system was in process of booting up from the crash. In the past we have had the system freeze and crash and restart. But this time when the system finally booted up, We are unable to get any module of RMS working again. We have tried system restore without any luck. Also we have tried to run Microsoft Update. But none of these have solve the problem. I would like to get help on how to get the system up and running again. I have back up of the data made minutes before the crash during a shift change. Currently we are getting the following error messages when attempting to get RMS going again:
These are the messages when attempting to start the system from the state it was in right after the crash: System Administrator : Pop Up Header: Store Operations Administrator Pop Up Text: Run-time error '-2147024703(800700c1)': Automation Error %1 is not a valid WIN32 application OK Manager Module: Pop Up Header : Store Operations Business Rules Pop Text : Error # -2147221164 Class not registered (Source : Provider) (SQL State:) (Native Error : -2147221164) No Help File Available Select * FROM Configuration OK
Pop Header 2 : Store Operations Business Rules Pop Text 2 : Error # -2147221164 Class not registered (Source : Provider) (SQL State:) (Native Error :
-2147221164) No Help File Available Select * FROM CustomCaption
OK Pop Header 3 : Store Operations Manager Pop Text 3 : Class not registered OK
POS Module: Pop Up Header : Store Operations Business Rules Pop Text : Error # -2147221164 Class not registered (Source : Provider) (SQL State:) (Native Error : -2147221164) No Help File Available Select * FROM Configuration OK
Pop Header 2 : Store Operations Business Rules Pop Text 2 : Error # -2147221164 Class not registered (Source : Provider) (SQL State:) (Native Error :
-2147221164) No Help File Available Select * FROM CustomCaption
OK Pop Header 3 : Store Operations POS Pop Text 3 : Class not registered OK SQL Manager: Start-> Microsoft SQL Server 2005 -> Configuration Tools -
SQL Server Configuration Manager
Error Pop Up Header : Microsoft Management Console Error Pop Up Text : mmc Cannot open file : C:\Windows\system32\SQLservermanager.msc this may be because the file does not exist, is not on mmc console, or was created by a later version of mmc. this may also be because you do not have sufficient access rights to the file.
If attemping to update the computer thru Microsoft Update, The process goes smoothly till XP SP3 update is applied and then the computer starts becoming unpesponsive(esp. Internet Explorer) A lot of popups for serious system problems. Also further updates thru Microsoft Updates are not possible because Internet Explorer freezes up Following Error messages pop up when attempting to run RMS in this state of system
System Administrator: Module loads up, but Server is not connected. Attempts to connect with the server for database connection produces a error message as follows : Pop Up Header : Connect. Pop up Text : SQL Server does not exist or access denied. ConnectionOpen(Connect()). OK Manager Module: Module does not load up. Give a error message as follows Pop Up Header " Database Failure" Pop Up Text "Could not connect to the database. OK POS Module: Module does not load up. Give a error message as follows Pop Up Header " Database Failure" Pop Up Text "Could not connect to the database. OK SQL Manager: Start-> Microsoft SQL Server 2005 -> Configuration Tools -
SQL Server Configuration Manager loads up but shows that, SQL Server
is turned off (Stopped). Attempts to starts the Server gives the following error message : The request failed or the service did not respond in a timely fashion. consult the event log or other applicable error logs for details,. OK
Any help on how to go about fixing this system will be highly appreciated. We are located in Phoenix Metro Area and any recommendations about local support help will be nice too.
Thanks,
Manager, BBazaar.