This document helps you to install the DinePlan and the SQL Server and configuring the SQL Server to access from all Terminals in the Locations
QUICK REFERENCE
We have a default Login User name and Password for SQL Server and we have default admin password for DinePlan.
SQL SERVER | User: sa Pass: ahghbfgfc |
DINEPLAN | 1111 |
PRE-REQUISITE FOR DINEPLAN
OPERATING SYSEM | WINDOWS 7/POS READY 7/8/10 or Above |
SOFTWARE | MICROSOFT .NET 4.5 or ABOVE |
For Server, we should have the SQL SERVER EXPRESS 2005 or ABOVE
DINEPLAN INSTALLATION
Here are the Steps to be done for the Dineplan Installation.
...
Note: See below for instruction on installing the SQL Server database software. SQL Server is used to store and manage the data used by DinePlan.
INSTALLING SQL SERVER EXPRESS
Before installating the SQL Express, please make sure that the system is 64 BIT or 32 BIT. The respective installer has to be downloaded from the Repository.
...
STEP 13: Close the initial startup SQL Server Installation Center screen.
...
CONFIGURE SQL SERVER TO OPEN THE PORT
This only needs to be done only in the Server and your location atleast one terminal
...
STEP 11: After Restarted. Close the SQL Server Configuration Manager.
WINDOWS FIREWALL
Add the Port to the Windows Firewall exceptions list or Inbound and Outbound Rules. The Windows Firewall can be accessed through the Windows Control Panel.
...
STEP 3: 'Turn Off' the Windows Firewall and click 'OK'.
...
RESOLVING SQL SERVER CONNECTION ISSUES
Check 1 - Services
After install SQL Server, bring up SQL Server Configuration Manager and check Services are operational as depicted below:
...