...

• A hosted environment solution (e.g., Citrix or Remote Desktop Protocol (RDP)).

Step 1 - Install Microsoft SQL Server 2008

Installs Microsoft SQL Server 2008 (MSSQL) on the server. Refer to the Microsoft SQL Server 2008 home page for more information about this product.

Important: If Microsoft SQL Server 2008 is already installed, you must still configure Microsoft SQL Server 2008 to allow remote connections.

...

Due to the range of versions and platforms available for Microsoft SQL Server 2008, the following instructions are based on the 32-bit Express Edition (with Advanced Services) of MSSQL. Your IT Support team can use this as a guide to installing other editions and platforms.

Pre-Requisite Software For Microsoft SQL Server 2008

The following software are required to be installed on the system prior to installing MSSQL 2008.

Note: The following list of software may have been installed on your system using Microsoft Windows Updates.

• Microsoft DotNet
• Microsoft Windows Installer
• Microsoft Powershell

Install - Microsoft SQL Server 2008 (Express Edition With Advanced Services)

Important: Prior to installing Microsoft SQL Server 2008, run Microsoft Windows Update to get the latest hotfixes for the previous Microsoft installations.

1. Open Windows Explorer.
2. Browse to: \[fw folder]\Setup\Database - MSSQL\Microsoft - SQL Server 2008 Express\
3. Double click the relevant setup file. The Microsoft SQL Server installation will begin.
4. From the sidebar, select Installation.
5. Click New SQL Server stand-alone installation or add features to an existing installation. The Setup Support Rules step will be displayed.
6. Click the OK button. The Product Key step will be displayed.
7. Click the Next button. The License Terms step will be displayed.
8. Tick I accept the license terms.
9. Click the Next button. The Setup Support Files step will be displayed.
10. Click the Install button.
11. Once the process is complete click the Next button. The Feature Selections step will be displayed.
12. Click the Select All button. All of the features will be selected.
13. Click the Next button. The Instance Configuration step will be displayed.
14. Select Default instance.
    
    Important: If including an instance name, the full name (including the server name) cannot be longer than 16 characters. At 24 characters, the example servername/instance_name exceeds the maximum characters allowed.
    
    
15.  Click the Next button. The Disk Space Requirement step will be displayed.
16. Click the Next button. The Server Configuration step will be displayed.
17. Select or enter an account name for each service, if required.
18. Click the Next button. The Database Engine Configuration dialog will be displayed.
19. Click the Add button to select users or groups.
    OR
    Click the Add Current User button to add the current user only.
20. Click the Next button. The Reporting Services Configuration step will be displayed.
21. Click the Next button. The Error and Usage Reporting step will be displayed.
22. Click the Next button. The Installation Rules step will be displayed.
23. Click the Next button. The Ready to Install step will be displayed.
24. Click the Install button. The installation progress will begin.
25. Once the installation is complete click Next. The Complete step will be displayed
26. Click the Close button to complete the installation.
27. Close SQL Server Installation Center.

Configure - Microsoft SQL Server 2008 To Allow Remote Connections

Important: This only applies to organisations that:

1. Have installed the Express or Developer Edition of Microsoft SQL Server 2008.
   AND
   Who wish to allow remote connections to the server from a client workstation.
2. Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager).
3. Expand: SQL Server Network Configuration > Protocols for [SQL]
4. Enable TCP/IP.
5. Enable Named Pipes.
   
   Note: A warning prompt will inform that these changes will not apply until the service is shut down and restarted. All SQL services, including server browser, need to be restarted.
   
   
6. Close SQL Server Configuration Manager.
7. Restart the SQL Server Service.

Install - Service Packs And Windows Update

Service Packs may be available for Microsoft SQL Server. Please check the Microsoft site (www.microsoft.com.au) for more information.

After installing any service packs, perform a Windows Update.

Step 2 - Configure Microsoft SQL Server Security

...

1. Start Framework Logistics Tablet (Start > All Programs > Insula Software > Framework Logistics Tablet).
   Tip: Double-click the Logistics Tablet desktop icon.
   Note: A dialog prompt asking to connect to the server will be displayed.
2. Click the Yes button to connect to the Framework server and configure the site. The Framework Logistics Synchronise dialog will be displayed and the software will attempt to connect to the server.
3. After successful connection, run the scheduled task that was created in Step 10 - Create a Scheduled Task.

Step 13 - User Acceptance Tests

The following is a list of view only tests that should be performed after updating the application.