# Kiss SQL Server Setup Method 2

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.

- Launch Kiss32S as a windows administrator
- If this is the first time you have installed Kiss32 the Set Connection Information Dialog will appear.
- Complete the information as a user with access to the master database such as sa. Set the database name to kissdata.
- Press the Build String Button and the Test String Button until you get the Connection to Database successful message.
- Click on Create Database and browse to the file KISSDATA.KBK. 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.KBK and press OK You should then get a message indicating the database has been created.

Optional Configuration for Networking without a domain (Requires Microsoft SSMS).

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

1. Set the system to mixed mode authentication:

- Log in to the Server in SSMS. 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'. Press OK

2. Create new user kissuser

- Navigate to Security then Logins. right click on Logins and select new login. 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