Cuberry requires some basic IT technical skills for if you are going to install it manually.
First you have to download and install MS SQL Express 2005 or 2008 on your PC.
You also have to make sure the the .Net 4.0 Framework is installed on your machine.
File System:
Extract the files from the downloaded Zip file on your C:\ root directory. All files are placed in the Cuberry directory, so can be found on C:\Cuberry after the extraction.
If you have extracted the files in another directory then please do the following:
1. Open "\Cuberry\Setup\CuberryAttach.sql" in Notepad and change the lines path "C:\Cuberry\CuberryDB\P2Cuberry.mdf" and ".ldf" to the correct location of the database files.
2. Right click the downloaded file, click properties and click on "Unblock" in the General tab.
3. Open "\Cuberry\Setup\Run CuberryAttach Script.cmd" in Notepad and change the path "C:\Cuberry\Setup\CuberryAttach.sql" to the correct location of the "CuberryAttach.sql" file.
4. Run the "Run CuberryAttach Script.cmd" Script.
Installation on Windows 7:
If you are installing on a Windows 7 OS you may get the "create database permission denied in database master" message when trying to attatch the database with the "Run CuberryAttach Script".
You have to change the security settings of your PC to run the script.
Turn User Account Control on or off
1. Open User Account Control Settings by clicking the Start button , and then clicking Control Panel. In the search box, type uac, and then click Change User Account Control settings.
2. Do one of the following:
» To turn off UAC, move the slider to the Never notify position, and then click OK. If you're prompted for an administrator password or confirmation, type the password or provide confirmation. You will need to restart your computer for UAC to be turned off.
» To turn on UAC, move the slider to choose when you want to be notified, and then click OK. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Database Connection String:
If you are using SQL Express on your PC, no additional database configuration is needed as the pre-configuration of Cuberry is to use SQL Express by default.
If you are using SQL Server (not the Express Edition), you need to configure Cuberry so it can connect to your database.
In the CuberryBinaries directory you'll find three .config files:
1. P2.Cuberry.exe.config
2. P2.Cuberry.exe - SQL Server.config
3. P2.Cuberry.exe - SQL Express.config
The first and the third file are exactly the same and are used in case an MS SQL Express edition is installed.
The second file should be used in case if a full MS SQL Server is in place.
You need to rename the file to be "P2.Cuberry.exe.config".
But if you want to do this manually you need to open C:\Cuberry\CuberryBinaries\P2.Cuberry.exe.config in Notepad and change the configuration.
There are four connection strings in the .config file, which can be used to split the database on different database servers.
Currently you may use: Logging, Security, Reports and the main application (Business).
Search for "ConnectionString" and replace the connectionStrings section to match your database server host name and credentials.
If you are running it on your local machine and you don't use credentials to access the database:
connectionString="Data Source=.;Initial Catalog=P2Cuberry;Integrated Security=True;MultipleActiveResultSets=True"
providerName="System.Data.SqlClient"
Or if you use a user ID and password and run the SQL Server on your local machine:
connectionString="Server=(local);Database=P2Cuberry;uid=YourUserID;pwd=YourPassword;"
providerName="System.Data.SqlClient"
The standard connection sting looks like follows:
connectionString="Data Source=.\SQLExpress;Initial Catalog=P2Cuberry;Integrated Security=True;MultipleActiveResultSets=True;Enlist=false"
providerName="System.Data.SqlClient"
Reporting Services
If you want to use the Financial Reports you have to upload the reports in the 'FiAccounting Reports' directory to your reporting server.
You also need to reset the configuration entry in the XAppConfig table. Change the ConfigValue from http://localhost/reportserver to your reporting server URL.
The Reports are in an SQL Server 2005 version. If you are running a higher version of the MS SQL Reporting Server they may not run.