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.