Difference between revisions of "POS Retail System Device"
| Line 9: | Line 9: | ||
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. | 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 == | ==Installing and maintaining the Receipt Printer== | ||
=== Knowing our 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. | 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. | |||
Revision as of 20:23, 13 September 2018
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.