Installation of Microsoft SQL Server Database

6.10.1.1 Step 1: Download SQL Server 2005 Express Edition

To install Sql Server 2005, execute the installation according to the section Install SQL Server 2005 in http://msdn.microsoft.com/en-us/library/ms143219.aspx#,

or for the SQL Server 2005 Express edition,

Install SQL Server Express from

http://msdn.microsoft.com/en-us/library/ms143722.aspx

or install SQL Server 2005 Express Edition with Advanced Services SP1 on from

Note! You will need a DB password to complete the installation. Obtain this password from your Aligned AG contact.

6.10.1.2 Step 2: Install database software prerequisites

Install the following items in order.

Internet Information Server 5 or higher

If your Windows server does not have IIS installed, go to Start | Control Panel | Add or Remove Programs | Add/Remove Windows Components. It is not a must to install this component but it is an official prerequisite none the less.

.NET Framework 2.0

If it is not installed already on your machine, download the .NET Framework 2.0 (x86) from

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd- aab15c5e04f5&DisplayLang=en

After downloading, execute dotnetfx.exe and follow the instructions to complete the installation.

MSXML6

Download MSXML6 from

http://www.microsoft.com/downloads/details.aspx?familyid=993C0BCF-3BCF-4009-BE21- 27E85E1857B1&displaylang=en

Execute msxml6.msi. This is a quick installation.

6.10.1.3 Step 3: Install SQL Server 2005 Express Edition

The name of the downloaded file is SQLEXPR_ADV.EXE. Double-click this file to start the product installation. The contents of the file are extracted and the installation begins.

After you start the installation, you have to agree to the typical End User License Agreement after which you're presented with a screen that shows you what prerequisites you need to get the express edition on your system. The installer will handle the installation of these prerequisites for you. Click the Install button to install these items if you are prompted to install any. Once the items are installed, click the Next button.

In Figure B below, the installer will scan your computer and check that it meets all install

requirements. However, some warnings are not show-stoppers, so you can continue. Note that the installer provides you with a complete status report to make it easy for you to determine what needs to be done.

If you have any serious problems, correct them before you continue.

After that, you have to provide your name and, optionally, your company's name. Un-check the box marked "Hide advanced configuration options"

Provide registration details for your server installation.

VERY IMPORTANT! In the dialog depicted in Figure E, - Select “Mixed Mode”

- Enter a password for the sa user.

Choose the mode under which you want to authenticate SQL Server users.

These options are not important to Aligned Elements. Continue with standard settings.

Figure G

Decide whether you want to enable support for user instances.

Figure H

These are all of your options for SQL Server 2005 Express Edition. Continue on to install the product using these selections.

6.10.1.4 Step 4: Install full-text filter packs

You now need to install a filter pack to allow sql server to read the content of different document types (e.g. doc, docx)

Download from http://www.microsoft.com/download/en/details.aspx?id=20109. Select the correct version depending on your OS (32 or 64 bit)

Start installation by clicking on FilterPackx86.exe (or FilterPackx64.exe) To register the filter packs, please follow these steps (from

http://support.microsoft.com/kb/945934) 1. Start SQL Server Management Studio.

2. In SQL Server Management Studio, select the instance in which you want to enable IFilters, and then run the following command in that instance:

sp_fulltext_service 'load_os_resources', 1

3. If you are running SQL Server 2008, go to Step 4. If you are running SQL Server 2005, stop and restart the msftesql service. To do this, follow these steps:

a. At a command prompt, type the following command and then press Enter:

net stop msftesql

Note To stop the msftesql service for a specific instance, run the following command:

net stop msftesql$InstanceName

b. At a command prompt, type the following command and then press Enter:

net start msftesql

Note To start the msftesql service for a specific instance, run the following command: net start msftesql$InstanceName

4. Restart the SQL Server service.

6.10.1.5 Step 5: Adapt the SQL Server Instance User Account

Start SQL Server Management Studio Express

In the log in box use the option as displayed below. NB! The server name must correspond to your computer name. The instance name is “SQLEXPRESS” by default.

-In the “Security” folder, select the “Logins” folder, right click and select the option “New Login…”.

-Create a new user name with the name “AlignedElement” (not “AlignedElements”). -Set the password to the password that you have obtained from your Aligned contact. -Check “Enforce Password Policy” and uncheck “Enforce password expiration”.

-Make sure that the user “AlignedElement” is assigned to the Server Roles “public” and “sysadmin”.