OVERVIEW

SliQ Invoicing can work with local company files on your hard drive or it can connect to a database server running on another PC.

To work with local company files all you need do is install SliQ Invoicing on your PC and then create a company and start raising invoices.

To allow client/ server operation, SliQ Invoicing uses Microsoft's SQL Server as a database server to contain your company files.

You can download and install Microsoft's free version SQL Server Express onto a PC that you want to use as a server. Alternatively, SliQ Invoicing can work with your existing SQL Server installation. The following picture shows how, in Server Mode, multiple users/ PCs running SliQ Invoicing can access a server PC running SQL Server.

Note: SliQ Invoicing can also be run on the server PC.

For more information, see:

• Downloading SQL Server Express
• SQL Server Login
• Working With Companies in Server Mode

Downloading SQL Server Express

You can download SQL Server from this page. If you want to use Microsoft's free version, download the Express edition.

By default, the free SQL Server Express is not configured to allow access over a network. To enable network access, do the following:-

• From the Windows Start menu, run SQL Server Configuration Manager. Under the SQL Server Network Configuration node, make sure TCP/ IP is Enabled.
• In your installed antivirus or firewall software, set an exception to allow SQL Server Express to accept connections.

Note: Setting up SQL Server can be complicated depending on your particular IT setup. Unfortunately, as each IT system is unique, SliQTools cannot provide support to help you set up your server or SQL Server. If you need support please use your own/ local IT support.

For simpler IT systems, consisting of a network of Windows 10 Professional systems, see Server Setup for more help. Note that the help on this page is only provided for guidance.

SQL Server Login

The SQL Server login you use with SliQ must have the following privileges in SQL Server:

• Alter Any Database
• Connect SQL
• Create Any Database
• View Any Database
• View Server State

For ease of use, it is recommended that you use the same SQL Server login in SliQ on each client PC. If you use different logins, ensure that each login can access the SliQ databases on the server that you want the clients to access.

Remember that the SQL Server login will need to match the following complexity rules:-

• The password should not contain the account name of the Windows user.
• The password should be at least eight characters long.
• The password contains characters from three of the following four categories:
• Uppercase letters (A through Z)
• Lowercase letters (a through z)
• Digits (0 through 9)
• Non-alphanumeric characters, e.g. exclamation point (!), dollar sign ($), number sign (#), or percent (%)