Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lovethepirk
Starting Member
2 Posts |
 Posted - 2009-12-18 : 14:38:05
|
| I am good with computers, I used to moderate forums for Malware, but I know nothing really about SQL stuff or networking...My buddy runs a bar and the Point of Sale computers(POS) around the bar are booting up and sticking at this error prompt:searching for server (BOOTP)...From what I understand the clients have no harddrive or OS on them and they are trying to contact the host computer for an TCP/IP address.The host computer is operational with XP pro installed and the POS software is by a company called "Squirrel". They cannot help unless they spend 15K on a new upgrade.I think this is an easy fix for an experience person. Is there a command within DOS or something in the Microsoft SQL I can run to find and detect these computers and get them up and running?Thanks in advance, much appreciated...LTP |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lovethepirk
Starting Member
2 Posts |
Posted - 2009-12-18 : 14:51:52
|
| Thanks for the response, where do you think I could get help online?thanks,ltp |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-21 : 05:23:53
|
| Hi lovethepirk,Don't know if you are still reading this but:I used to work for a uk POS company (not squirrel but probably like them)bootp is a really simple ftp like program usually kept on the firmware of the device in question. Probably what the pos is doing is trying to load it's operating system off a network device (most likely the server you mentioned).Your first few steps are obvious.Id guess that either1) There is a network problem between the POS and the server. Are other POS similarly afflicted or it this the only one? If the others are the same then there is a connectivity problem. In a bar then someone has probably switched off a hub or switch.2) A router / other DHCP server has stopped working on the network -- maybe that might be your office PC, maybe it's a hardware device.3) Something has changed on the office pc / server. has someone been adding or removing programs?4) If it is only one till (it sounds like all of them) then it could be the battery in the till has gone which would make it loose a permanent Ip address stored in cmos.From your description it sounds like either 1 or 2 has happened.I'd recommend that:1) check all the cables and connections. Maybe a cat5 cable has been simply unplugged or a switch / hub has been switched off.2) Try switching the pos off, the computer off, all the network infrastructure off. Then switch on the network infrastructure. Wait 2 minutes, switch the computer on and wait for it to completely start up. Then switch on the point of sale devices.3) if you can't find the problem yourself, call squirrel again and just complain. Presumably they sold the bar a support contract with the sale and the problem is definitely *not* anything to do with a software upgrade -- this is a bare bones connectivity problem.Best of luck.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
|
|
"searching for server (BOOTP)..."