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