Timesheet Rostering Software | Staff Management Software | Temporary Staff Software | Nurse Bank Software | Nursing Agency Software | Employee scheduling software

AvaPA can be used with all editions of MS SQL Server 2000 or 2005 except the compact edition (which is specifically for mobile devices).

For most Agencies or Employment Banks the Express editions of these database engines will provide storage for between one and two million shifts.

 

Microsoft only supports SQL 2005 SP2 or higher on the Vista platform.

 

Microsoft SQL Server 2005 Express Edition, is a vanilla flavour edition of SQL Server 2005. It can be easily upgraded to other versions of SQL Server if it becomes necessary to store more than a million or so shifts.

 

If you wish to install or re-install AvaPA on a Vista Computer, you will need to carry out the following steps: (You may also contact Ava support for guidance through this process)

 

Note: you may also wish to install SQL Express Management Studio and any prerequisites for these applications. There are no additional licence fees or payments associated with these installs.

 

Download Microsoft SQL Server 2005 Express Edition SP2 from the Microsoft web site:
http://go.microsoft.com/fwlink/?LinkId=65212

  

Save the SQLEXPR32.EXE file to some recognisable location (your desk top, documents folder or created an "install" folder somewhere.)

When downloading has finished, double-click the SQLEXPR32.EXE file to start the installation process.

If prompted: Click Run

If prompted   Click Continue.

Check the box at the bottom of the window: "I accept the licensing terms and conditions".

Click Next.

 

 

Click Install.

Click Next.

Click Next.

Click Next.

Click Next.

Enter your Name and Company details.

Un check "Hide advanced configuration options".

This is very important otherwise options you will need will be hidden.

 

 

Click Next.

If not already unselected: De-select all Client Components.

 

 

Click Next.

Select "Named instance"

Replace the SQLExpress name with "AvaPA".

 

 

Click Next.

Select "Use the built-in System account" and choose Network service.

Check mark in the box next to "SQL Server" to start the SQL at the end of the setup.

 

 

Click Next.

Select "Mixed Mode (Windows Authentication and SQL Server Authentication)".

Enter the "sa" logon password connect to SQL Server "sa" account.
Enter it again in the confirm box.
Make a note of this password and store it in a secure document!

 

 

Click Next.

Select "collation sort order and designator"

 

 

Click Next.

 

 

UN check "Enable User Instances".

Check Add user to the SQL Server Administrator role

 

 

Click Next.

Click Next.

Click Install.

Click Next.

 

Click Finish.

Make sure your settings are supported

By default, the latest version of SQL Express has "Auto close" and "Auto shrink" set to true. These both need to be set to false to be supported by Ava. Follow the guide on the page linked below for steps on how to achieve this:

Supported SQL Server settings guide