SUPPORTED MICROSALE VERSIONS: 9.0.701 AND HIGHER
MicroSale has created a quick installer for SQL which bypasses the manual setup process (You no longer need to enable the “Named Pipes” SQL protocol or the “TCP/IP” SQL Protocol. Please make sure you are using a supported version of software or will immediately upgrade MicroSale after running the SQL Installer.
Installing the SQL Express Quick Installer
The Quick Installer is located on the FTP Site
- From the FTP site: MSaleDealer > $M$CD > Install Files> Interface Install Files>MicroSale SQL Server 2008 R2 Express or MicroSale SQL Server 2012 R2 Express (Select the appropriate SQL installation folder based on your computer’s operating system (64bit or 32bit) or use the following link: msawww.microsale.net/download/SQLx86Tools.zip or www.microsale.net/download/SQLx64Tools.zip
- Save the MicroSale SQL Server 2008 R2 Express folder locally
- Open the folder from your computer
- Double-Click on the “MicroSale SQLExpress Installer (x86 or x64).bat” file to begin SQL installation
- Open the SQL Server Backwards Compatibility Patch folder and run the msi file using Windows Installer
- Continue to click “Next” and do not change any default settings
- Install MicroSale and/or upgrade MicroSale to Version 9.0.701 or higher
- Choose either Full Service or Quick Service configuration on page 2 then proceed to step 9
- Assign remote register locations
- Create/update SQL databases
-----------------------
USE THIS SECTION FOR FULL SERVICE
Configuring SQL within MicroSale for Full Service (where checks are shared between terminals)
- Start the MicroSale software
- From the Managers Menu, go to Register Setup then Paths – Terminal Setup
- Select Sql Server Setup (red button on top right)
- Select Find Servers
- When the list of all computer names on the network appears in the box, click on the restaurant’s server PC Name or on the workstation PC Name that will be deemed as the server
- When the PC name is highlighted, click in the Local Sql Server field (the IP address will automatically populate)
- Highlight the same PC name again and click in the Main Sql Server field (the IP address will automatically populate)
- Proceed to last section.
-----------------------
USE THIS SECTION FOR QUICK SERVICE
Configuring SQL within MicroSale for Quick Service
- Start the MicroSale software
- From the Managers Menu, go to Register Setup then Paths – Terminal Setup
- Select Sql Server Setup (red button on top right)
- Select Find Servers
- When the list of all computer names on the network appears in the box, click on the Local PC Name
- When the PC name is highlighted, click in the Local Sql Server field (the IP address will automatically populate)
- Highlight the Server’s PC Name or the workstation that will be deemed as the Server and click the Main Sql Server field (the IP address will automatically populate)
- Proceed to last section.
-----------------------
- Select Set By Default to populate the User Name and Password
- Select the Gift/House/Frequent Diner Server (this may be the Main Sql Server or an offsite server – test the connection to ensure proper setup by selecting “Test Connection”)
- Select Save
- Select Build / Update Databases
- Select Load SQL
- Select Select All
- Select Create/Update (wait a few seconds until the prompt appears)
- Select Exit
- Select Exit again from the Setup Screen
- Setup the Server Name and Common Register Name (The common register name is typically the main server)
- Select Save and then Yes to Update All Remotes
- Restart MicroSale to verify proper setup
- In the lower right corner of the screen, you should see “Sql” listed by the version number. If Sql does not appear, please contact technical support
Assigning Remote Register Locations
- Start the MicroSale software
- From the Managers Menu, go to Register Setup then Paths – Terminal Setup
- Click on Remote Register Setup.
- Click on “Select Remote Register” to display a list of remote locations.
- Select the location to populate the “Remote Register Name” field.
- Click on “Load Servers” to display a list of SQL instances on the network.
- Select the SQL instance for the register selected in step 5 and click on the “Terminal SQL Server” field.
- Select Save
Creating and Updating the SQL Databases
- Go to Managers Menuà Register Setupà Setup/Configuration.
- Select the button on the bottom left corner called “Database Update” to access the MicroSale Database Utility.
- Select “Load SQL” to display a list of all SQL DBS files.
- Select “Select All” to place a check in the box next to all of the SQL DBS files.
- Touch the “Create/Update” button to build the SQL databases.
- When the build is complete a message will display with an “Update Completed” message.
- Click “Ok” to accept.