Kiss SQL Server Setup Method 1

Kiss SQL Accounting requires a Working Version of SQL Server or the free SQL Express to be installed. While it is outside the scope of this document to show you how to do this don't be put off as installation is pretty easy and there are lots of good articles on how to do it. This article assumes you have a version of SSMS installed too.

• Launch SSMS and login to your SQL server using a login that allow you to create a database such as sa.
• Navigate to the Database Folder ,right click and click on select 'New Database'. Type KISSDATA as the Database Name and press OK. You now have a new empty database called KISSDATA.
• Select to the newly created database KISSDATA. Right click, select task, then restore and then database. This will launch the Restore Database Dialog.
• From the General section select device. Using the backup media type File press add and browse to the file KISSDATA.BAK. In a standard install this will be located in 'c:\programdata\kiss32S\backups' (a copy can also be downloaded from  'https://kissltd.co.uk' ) Click on the File KISSDATA.BAK and press OK. Press OK to return to the Restore Database Dialog.
• Click on Options and select the Overwrite the existing database  (WITH REPLACE) and the close existing connections to the destination options. Press OK to Restore the Database.

Optional Configuration for Networking without domains..

If you intend to run Kiss SQL Accounting on a network without domains the following additional configuration is recommended.

1. Set the system to mixed mode authentication:

• Right-click the server and then click Properties.  In the SQL Server Properties dialog box, click the Security tab. Select the 'SQL Server and Windows Authentication mode' is selected . Press OK

2.Create new user kissuser

• Navigate to Security: Logins. right click on Logins and select new logins. Under the login Name enter kissuser. Select SQL Server authentication and KISSDATA as the default database. Enter a strong password under password and confirm password.
• Navigate to user mapping and select the KISSDATA database. Press OK.

3. Allow network access (From Windows)

On the machine where SQL Server is installed run services.msc. Double click on SQL Server (My Instance). Under Log On select this account choose an administrator name and password and press OK. Right click on SQL Server (My Instance) and select restart