POS Retail System Device

Fixing the SQL Server

WMI Errors

You'll experience an error with "WMI" if you attempt to use any of the prebuilt SQL Server management options, but don't worry about this. We won't be using the prebuilt SQL Server management options, so this WMI error is basically useless to us to fix.

Use SQL Server Management Studio

SQL Server Management Studio (SSMS) will be our playground for managing the databases for SQL Server 2005 and SQL Server 2008 R2. Both versions are installed onto the Windows XP box, and for good reason, as SQL Server 2008 R2 is a lot easier to manage than 2005, but 2005 is required for POSitive Retail Manager to function, so DO NOT REMOVE SQL SERVER 2005.

Once inside of SSMS, you will need to log in to a master database manager, and to do so you will need to click on New Query then log in as MHS-RETAIL using Windows Authentication, no password. Here you'll be able to restore databases from backup, create a new database, or manage existing ones. It is recommended to restore from a database backup off of the USB stick that Mr. Rodriguez has, seeing as it's already formatted for POSitive Retail Manager and Copa Corner. There's not much more to do with the SQL Server after this, so don't mess with anything else.

Installing and maintaining the Receipt Printer

Knowing our printer

The printer currently attached to the Windows XP POS box is an SNBC BTP-R180II (U), and it will stay that way. To manage the setting of the SNBC BTP-R180II (U), do NOT go through Windows GUI or Control Panel, instead, hold down the FEED button while powering up the device to print self-test mode. After the initial self-test, it will ask if you want to finish self-test or configure the settings, and you will hold down the FEED button until it prints out a menu.

Configuring our printer

As explained above, you will enter configuration mode through the printer itself. Once in configuration mode, the only option you need to check in order to ensure it can even connect to the POS Windows XP box is what mode it is in. To check the current mode of the printer, press the FEED button 7 times, then hold down the FEED button until it prints out the new page. Make sure the printer is in WinDriver mode, as it will not work on Windows XP in API mode. After checking this, you don't need to worry about any other configuration setting on the device. Don't forget to save, then exit configuration mode.

Installing the printer

Once you've checked to make sure the printer is in WinDriver mode, install the drivers (found here: https://www.crs-usa.com/products/printers/thermal-printers/snbc-btp-r180ii-thermal-receipt-printer-series-) while the receipt printer is plugged into the POS system AND powered on. Once it is installed, enter Printers and Devices through the Windows menu and ensure it is the default printer of the computer.

Installing the Cash Drawer

Installing the cash drawer

Take the ONE AND ONLY cable sticking out from the back of the cash drawer and plug it straight into receipt printer. That's it, don't do anything else. I'm serious.

Installing the Barcode Scanner

Installing the barcode scanner

Take the USB cable that's connected to the scanner and plug it in. Make sure the drivers are installed (there aren't any special ones online) correctly through Windows XP automatic installer, then you're done.