Versions Compared

Version Old Version 3 New Version Current
Changes made by

Julie Doyle-Whitelock

Julie Doyle-Whitelock

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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: 

Warning

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.

...

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

...

Warning

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.

    Warning

    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.

...

  1. Open the Security
  2. Open the User screen (Security > User).




  3. From the Security Group drop-down list, select Guest Users. The User list will be refreshed.

    Tip

    Repeat steps 9-14 to add more region/divisions. The following is an example of a completed Region/Division list.


  4. Click the New The User (General tab) dialog will be displayed.



  5. Enter the required General information
    • Staff: Click the Staff popup button to select or enter a new staff member.
      Example: Hosted Logistics
    • User Group: Ensure the group is the security group the hosted logistics user belongs to.

  6. Enter the required Password Example: 0000

    Warning
    Important:

    The Password and Confirm Password fields should be a numerical value to reflect the numerical login screen of Framework Logistics Tablet. This password will be given to those staff that are to have access to Framework Logistics Tablet in a hosted environment.


  7. Enter the Notes information, if required.
  8. Select the Region/Division



  9. Click the New toolbar icon. The User Region/Division dialog will be displayed.



  10. Enter the required General information, if required.
  11. Enter the required Log In information, if required.
  12. Enter the required CRM Tools information, if required.
  13. Enter the required Work Flow Analysis information, if required.
  14. Click the OK The User Region/Division dialog will close.
  15. Click the OK The User dialog will close.

...