Difference between revisions of "POS Retail System Device"
(Created page with "== 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...") |
|||
| Line 1: | Line 1: | ||
== Fixing the SQL Server == | ==Fixing the SQL Server== | ||
=== WMI Errors === | ===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. | 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 === | ===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 '''<u>DO NOT REMOVE SQL SERVER 2005</u>'''. | 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 '''<u>DO NOT REMOVE SQL SERVER 2005</u>'''. | ||
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 == | |||
=== 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. | |||
Revision as of 20:20, 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.