Knowledge Base

Knowledge Base
Advanced Search Search the Knowledgebase
 Featured
How to install Microsoft SQL Server 2008?
Author: Microengine Views: 12756 Created: 12-03-2015 10:01 AM 0 Rating/ Voters

This article contains steps to install Microsoft SQL Server 2008. This software will be using as database for xPortalNet software.

Applies To:

  • Software xPortalNet     
 Resolution Summary
          
 Resolution
 
Please complete the following steps to install the Microsoft SQL Server 2008.

Pre-requisite:

  1. Windows XP Pro, Windows Vista, Windows 7, Windows 8, Windows Server 2008, Windows Server 2008 R2.
  2. Microsoft SQL Server Management Studio.
  3. xPortalNet Installation CD.
  4. Microsoft SQL Server (Pre-Installation).
    » See
     
    AA-00275 to learn how to install the Microsoft .NET Framework v3.5.



Microsoft SQL Server 2008 Installation:

  1. Please make sure you have perform the Microsoft SQL Server (Pre-Installation) before start the installation.
  2. Open the xPortalNet Installation CD.


  3. The following files will be shown.


  4. Open file 2) Microsoft SQL Server 2008. The following files will be shown:


  5. You may open the Microsoft SQL Server 2008 Installation Guide.pdf for installation guide.
  6. To start the installation, right click and run the SQLEXPRWT_x86_ENU_2008.exe as administrator.


  7. Wait for the files to be extracted.
  8. If program compatibility windows is shows up, just run the program.


  9. Wait for the SQL Server Management installer to appear.
  10. At the SQL Server Installation Center:

    1. Select Installation at the left hand side menu.
    2. Then select the New SQL Server stand-alone installation or add features to an existing installation.  


  11. Setup Support Rules check will run. Make sure all the status are Passed.
  12. Click OK to proceed.

    » Restart PC if required by the setup.
  13. Wait for the SQL Server to process the operation.
  14. At the Product Key page, just click Next to continue.


  15. At the License Terms page, please read the License Terms carefully. If you agree to the License Terms, click Next to continue.

  16. At the Setup Support Files page, click Install to install the setup support files.
  17. Wait until the setup support files finished to install.


  18. At the Setup Support Rules page, please make sure the Status of the Rule is all Passed.


  19. At the Feature Selection page, please select Select All features then click Next to continue.

  20. On Instance Configuration page, select: 
    • Default Instance: To install as "MSSQLSERVER", or
    • Named Instance: To install as a name other than "MSSQLSERVER". Specify both Named Instance and Instance ID fields.
  21. Click Next to continue.

    Important: Note down the Instance Name/ Instance ID that you have entered.
    » This Instance ID
    will be used later to connect the xPortalNet software with the SQL Server during Database initialization.

  22. Make sure you have enough disk space before proceed with the installation. Click Next to continue.


  23. On Server Configuration page,
    • For SQL Server Database Engine, change its Account Name to "NTAUTHORITY\SYSTEM".
    • For SQL Server Browser, change its Startup Type to "Automatic".
  24. Click Next to continue.


  25. On Database Engine Configuration page,
    • At Authentication Mode:
      • Select Mixed Mode (SQL Server authentication and Windows authentication).
      • Enter and confirm password for Service Account (sa).
    • At Specify SQL Server administrators:
      • Click Add Current User. Wait until current computer user name appear.
    • Click Next.

      Important: Note down the password you have entered.     
      » This Password will be used later to connect the xPortalNet software with the SQL Server during Database initialization.
  26. On Error and Usage Reporting page, click Next to continue.


  27. On Installation Rules page, please make sure the Status of the Rule is all Passed.
  28. Click Next to continue.


  29. On Ready to Install page, click Install to start the installation.


  30. Wait until the installation is completed.


  31. Make sure the Status of the Feature Name is all Success. Click Next to finish the installation.

  32. You should see a message as shown below when the installation is completed successfully.


  33. Please restart your PC after finish the installation.
Custom Fields
  • Summary: This article contains steps to install Microsoft SQL Server 2008. This software will be using as database for xPortalNet software.
  • Search Tags: sql server, installation, xportalnet
Comments
  • There are no comments for this article.
Submit Feedback on this Article