...
- Open Windows Explorer.
- Browse to: \[fw folder]\Setup\Sentinel Protection Installer\v7.6.6\
- Double-click setup.exe. The Sentinel Protection Installer installation will begin.
- Click the Next button. The Licence Agreement step will be displayed.
- Select I accept the terms in the licence agreement.
- Click the Next button. The Setup Type step will be displayed.
- Select Complete.
- Click the Next button. The Ready To Install the Program step will be displayed.
- Click the Install button to begin the installation.
Important: If Windows Firewall is detected, click the Yes button. - Click the Finish button.
Step 2 - Install Microsoft SQL Server
...
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. For more information, see Configure - Microsoft SQL Server 2008 to Allow Remote Connections below.
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.
For a list of compatible SQL Server Versions, /wiki/spaces/FWKB/pages/211714546.
Pre-Requisite Software For Microsoft SQL Server
...
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
...
(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.
- Open Windows Explorer.
- Browse to: \[fw folder]\Setup\Database - MSSQL\Microsoft - SQL Server 2008 Express(Compatible Version) Express\
- Double click the relevant setup file. The Microsoft SQL Server installation will begin.
- From the sidebar, select Installation.
- Click New SQL Server stand-alone installation or add features to an existing installation. The Setup Support Rules step will be displayed.
- Click the OK button. The Product Key step will be displayed.
- Click the Next button. The License Terms step will be displayed.
- Tick I accept the license terms.
- Click the Next button. The Setup Support Files step will be displayed.
- Click the Install button.
- Once the process is complete click the Next button. The Feature Selections step will be displayed.
- Click the Select All button. All of the features will be selected.
- Click the Next button. The Instance Configuration step will be displayed.
- 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. - Click the Next button. The Disk Space Requirement step will be displayed.
- Click the Next button. The Server Configuration step will be displayed.
- Select or enter an account name for each service, if required.
- Click the Next button. The Database Engine Configuration dialog will be displayed.
- Click the Add button to select users or groups.
OR
Click the Add Current User button to add the current user only. - Click the Next button. The Reporting Services Configuration step will be displayed.
- Click the Next button. The Error and Usage Reporting step will be displayed.
- Click the Next button. The Installation Rules step will be displayed.
- Click the Next button. The Ready to Install step will be displayed.
- Click the Install button. The installation progress will begin.
- Once the installation is complete click Next. The Complete step will be displayed
- Click the Close button to complete the installation.
- Close SQL Server Installation Center.
Configure - Microsoft SQL Server
...
To Allow Remote Connections
Important: This only applies to organisations that:
- 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. - Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager).
- Expand: SQL Server Network Configuration > Protocols for [SQL]
- Enable TCP/IP.
- 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. - Close SQL Server Configuration Manager.
- Restart the SQL Server Service.
...
- Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
- Connect to the required server.
- Right-click on Databases and click Restore Database.... The Restore Database dialog will be displayed.
- In the To Database field, enter the Framework Database Name.
...
- Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 Server > SQL Server Management Studio).
- Connect to the required server.
- Expand: [Server Name] > Security > Logins
- Right-click the Logins folder and select New Login. The Login - New dialog will be displayed.
- Select the General
- Enter a Login Name.
OR
Click the Search button to search for a login.
Example: Domain\Domain Users - Ensure the selection for the Default Database is: master
- Select the User Mapping
- From the Users Mapped to This Login list, tick the required Framework database(s). The Database Role Membership For [Selected Database] list will be updated.
- For ALL Framework databases, ensure that the following two items are ticked:
- db_owner
- public
- Click the OK
- Close Microsoft SQL Server Management Studio.
...