The ShopClock Network Server
It is important that the computer chosen for use as the ShopClock server be up and running all the time. It can not hibernate, sleep, or be shut off or the ShopClock clients will not be able to run and will exit with an error message saying they can't connect to the server.
A named instance, SHOPCLOCK_SS, of Microsoft SQL Server Express, is used by ShopClock as its network server.
SQL 2019 Express
SQL Server Express 2019 is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications. SQL Express 2019 is a 64 bit version. Check out the other hadware and software requirements here. If a 32 bit version of SQL Express is needed see SQL Express 2012 at the bottom of this page.
1 – Download SQL Express
Download Sql Express 2019 directly from Mirosoft https://www.microsoft.com/en-us/sql-server/sql-server-downloads
2 – Choose the Custom Installation Type
3 – Select a New SQL Server stand-alone installation
4 – Check for and deal with any warnings
5 – Select the 3 features required for use with ShopClock
6 – The instance name and instance ID must be SHOPCLOCK_SS
7 – Set the startup type for the database engine and the browser to Automatic
8 – Set Authentication Mode to Mixed, and the password to G0ldf1ng3r@!
9 – Check the finish page for success
10 - Create the data tables and stored procedures used by ShopClock to automatically back up each day.
Bring ShopClock's Admin Window, Open tab 14 Network Setup, and click on the 'Use Network Server' button.
Refresh the server list, select this server, and click OK. ShopClock will finish configuring the network database and will then copy the local database up to the server
11 – Use the SQL Configuration Manager to enable TCP/IP so the ShopClock clients can connect to the server
12 – Add the SQL server exceptions to the firewall
This completes the instllation and configuration of the ShopClock on-premise net work server.
SQL 2012 Express
SQL Express 2012 is hybrid installation packages that can be used on both 32 and 64 bit computer
Requirements for SQL 2012
- For Windows 7 or Windows Server 2008 R2, Service Pack 1 or later is required.
- For Windows Vista or Windows Server 2008, Service Pack 2 or later is required.
- For more info see http://go.microsoft.com/fwlink/?LinkID=195092
Supported Operating Systems for SQL 2012:
- Windows 7, 8, 8.1, 10
- Windows Server 2008 R2 and newer
- Do not install this on a Domain Comptroller. See KB2032911 http://support.microsoft.com/kb/2032911
- (If you are using XP as a server, download MSSQL 2005 from the bottom of this page).
Scripted vs Interactive SQL Server Installation
The Scripted installation runs without asking for any input. Everything is installed in the default locations on drive c. The interactive installation give you the opportunity to put things where you want, but some settings are required for ShopClock to use the database. See the interactive instructions below.
Download and save it (scSqlServer2012Sp1Setup.exe) to your server's desk top, and after it's downloaded, double click on it to install the named instance (SHOPCLOCK_SS) of Microsoft SQL 2012 Server on your computer. That's it, no wizard, no decisions. Just wait until it finishes installing.
Use this to Upgrade SQL Server 2005 to 2012 or do a custom Installation of SHOPCLOCK_SS.
Download the interactive version. The interactive version gives you the choice of either upgrading an existing SQL instance to 2012 or of doing a new install.
To Upgrade MS SQL 2005 to 2012, just click on the UPGRADE button and follow the on-screen prompts. If you upgrade an existing 2005 ShopClock instance of MSSQL to 2012, you must also recreate the Auto Backup Devices on tab 11 (Backup/Restore Database) of the Admin window. Also be sure to install the latest version of ShopClock4 or ShopClock4Plus on the server. This later step is necessary for restoring the database. ShopClock3 can not restore the database to the 2012 instance - you must use ShopClock4 or 4plus.
To do a Custom Installation of the SHOPCLOCK_SS instance, click on the New Install button.
When doing a custom installation of the SHOPCLOCK_SS instance you must include the following settings. Settings like where things are installed are up to you.
After the ShopClock Server has been installed
- Bring ShopClock's Admin Window up and click on the 'Edit Network Database' button. Refresh the server list, select this server, and click OK. ShopClock will finish configuring the network database and will then copy the local database up to the server
- Check your firewall settings. If you are using a fire wall, either
- then turn it off or add exceptions for SQL Server. See Accessing the Network Database.
If you must Use a Windows XP Computer as the Server
Download ShopClock Network Server MS SQL 2005 Express Service Pack 4 (sqlSvr2005Sp4Setup.exe)