Bluchip Knowledge Base
Setting up a New Bluechip Database

Before you Begin

Please contact your System Administrator if you need assistance with the following:

o      Ensure you have logged into Windows with local Administrative privileges.

o      Ensure you have installed Bluechip on the Server computer.

o      If you are using Full SQL 2005 or 2008, you will need to download the required SQL Studio Management Tools from the Microsoft web site.

Install Microsoft SQL Studio Management

You will need to be on the Server computer. The 2005 SQL Studio Management installation file is installed with a default Bluechip installation, and can be found in the following location:

o      32 bit - C:\Program Files\Health Communication Network\Bluechip\Tools\

o      64 bit - C:\Program Files (x86)\Health Communication Network\Bluechip\Tools\

o      On the Bluechip CD, browse to \Microsoft SQL Server 2005 Express\ SQLServer2005_SSMSEE.msi

There are two versions (32-bit and 64-bit) of 2005 SQL Studio Management Studio Express. These are for 2005 SQL installations only - if you are using SQL 2008 please refer to Before You Begin, above.

o      32 bit - SQLServer2005_SSMSEE.msi

o      64 bit - SQL Server2005_SSMSEE_x64msi

Restoring the Bluechip Database

1.      Browse to the location of your Bluechip Database.

2.      Copy (do not ‘cut’) the Bluechip Database.

3.      Paste the Bluechip Database in either of the following locations, according to your SQL version and operating system:

OS Version

SQL Version

Folder Location

32 Bit

SQL 2005

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

SQL 2008

C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\MSSQL\DATA\

SQL  2008 R2

C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\




64 Bit

SQL 2005

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ MSSQL\Data\

SQL 2008

C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\

SQL 2008 R2

C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\

4.       Start SQL Server Management Studio.

From the Windows Start menu, select All Programs. Within the list of programs, locate Microsoft SQL Server and then locate and click SQL Server Management Studio.

Note: On Windows 7 computers, you may need to right-click SQL Server Management Studio and select ‘Run as Administrator’.


5.      Once SQL Server Management Studio has opened, you will be presented with a Connect to Server window. Check the following is correct then click Connect.

o      Server Type: Database Engine.

o      Server name: Server Name/HCNSQL07

o      Authentication.


6.      You will be presented with the Object Explorer screen.

7.      Click on the + to expand the databases.

8.      Right-click Databases, and select Attach.

9.      Click Add on the Attach Databases window. If at this stage you are presented with an error message, it may be you need to run SQL Server Management Studio with Administrative Privileges. Close SQL Server Management Studio, return to Step 4 and follow the instructions written under the Note there.

10.   The Locate Database File window will be presented. Select the Bluechip database.

11.   Click OK.

12.   You will be presented with the Attach Database window. Click OK.

The Bluechip Database is now restored.

Configure Bluechip

To switch between the Demonstration database and the customer’s Live database, follow the instructions below:

Create the Customer Data Folder

1.      Browse to the following location

o      Standalone Role

       32 Bit - C:\Program Files\Health Communication Network\Bluechip\BlueData

       64 Bit - C:\Program Files (x86)\Health Communication Network\Bluechip\BlueData


o      Server Role

       XP - C:\Documents & Settings\All Users\Documents\Health Communication Network\Bluechip\BlueData

       Win 7/2008/2011 - C:\Users\Public\Health Communication Network\Bluechip\BlueData


2.      Locate and copy the entire BCDemo folder.

3.      Paste the BCDemo folder into the same location.

o      Rename the copied BCDemo database to the customer’s database name.

Configure the Database.inf file

1.      Locate and open the database.inf file.

2.      Highlight and copy all text between and including the lines [BCDemo] and DBSQLDatabseImport=none

3.      Create space at the end of the file by pressing Enter.

4.      Right click and Paste the text.

5.      Change all references of BCDemo in the copied data to the customer’s Database name (as shown in bold below)

6.      Save the changes




DBSQLServer=Server Name\HCNSQL07




[Customers Database Name]



DBSQLServer=Server Name\HCNSQL07

DBSQLDatabasePractice=Customers Database Name







Now when Bluechip is started, both the demonstration database and the customer database will be available for use.