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