Starting a QikKids Database

Once SQL Express and the Management Studio have been installed, you can attach a QikKids database. If you already have a QikKids SQL Database, you can attach this, otherwise use the blank QikKids database from your QikKids CD (Tools\QikKids\BlankSQL).

If you need an existing QikKids Access database converted to SQL Server format, please contact your nearest QikKids office.

To attach a database:

Copy the database files (*.mdf and *.ldf) to a folder on the server. This folder should not be shared on the network. For this example the database files are QikKids.mdf and QikKids.ldf stored in c:\QkSQLDB.

Ensure that the network service account has full privileges to this folder.

Open the SQL Express Management Studio (Microsoft SQL Server)

1. The server name should be automatically set to the computer name
2. Set the authentication to SQL Server Authentication
3. Set the login to sa
4. Set the password to the sa password during installation of SQL Express
5. Press Connect

In the Object Explorer:

1. Right click on Databases and choose Attach
2. Press Add and browse to the folder and file containing the QikKids data file to attach, press OK
3. In the Databases to attach list edit the Attach As name to an appropriate name for your database. This is the name that you will use when specifying a connection from QikKids.
4. If an error occurs during the attach process, you will be returned to the attach screen. Click on the messages column in the attach list to see a description of the error.

Setting up User Accounts

You should create at least 2 user accounts for QikKids.

One account will be a general use account with Data Read / Write privileges. This will be used as the standard QikKids login for users.

The second account will have Owner privileges and will be used when QikKids needs to upgrade the database schema.

For this example we will create 2 accounts, QkUser and QkMaster. For security you should use different names to these.

In the Object Explorer:

1. Expand Security by clicking the + symbol
2. Right click on Logins and choose New Login
3. On the General page, enter the Login name you wish to give the standard user account
4. Switch to SQL Authentication and enter a password. This password should be a complex password, especially if your database will be shared over the Internet. Users will not have to remember this password
5. Remove the tick from Enforce Password Policy
6. Set the Default database to your QikKids database
7. Change to the User Mapping page
8. Tick your QikKids Database and tick db_datareader and db_datawriter. Remove all other ticks except public
9. Press OK to save

Repeat the same operation for the Master login account, except this time give the login account the db_owner right on the user mapping page.

When initially connecting to a QikKids database, QikKids will perform a schema upgrade if necessary. QikKids should login using the master account whenever an upgrade to the database scheme is required. The easiest way to do this is to set up the IT / Admin computer to always login with the Master account, this way it will control QikKids updates.