SQL Server 2008 Installation diagram

This article describes the hardware and software configuration requirements for installing SQL Server 2008 Enterprise Edition, the specific steps of the installation process, and the considerations that need to be taken into consideration.

Steps/Methods

2. 1

   Here we will illustrate the way. To describe the SQL Server 2008 installation and configuration process. We hope to help you.

4. 2

   Select the version number, or enter the key yourself to identify the version number

6. 3

   License Agreement

8. 4

   Supporting file Installation

10. 5

    Start checking yourself after installation

    Two warnings, one is. NET warning, said no network delay, or need to download files

    One number to open the port, ignore it, open it later.

11. 6

    Select installed features, SQL database and Administrative Tools

    Select an instance

    Drive Check

    Select a service account and select a Local System account

    Authentication mode: SQL and local mode, enter password, add Administrator, be able to join local group or current user

    Password complexity policies prevent brute force attacks by adding the number of possible password. When implementing password complexity policies. The new password must conform to the following principles:

    Password must not include all or part of the user account name. A partial account name is a continuous alphanumeric character separated by a "blank" (Space, tab, carriage return, and so on) or any of the following characters: a comma (,), a period (.), a hyphen (-), an underscore (_), or a number sign (#) for three or more than three ends.

    The password length is at least eight characters.

    Password includes three of the following four types of characters:

    Latin Capital Letter (A-Z)

    Latin Small Letter (A-Z)

    10 basic Numbers (0-9)

    Non-alphanumeric characters, such as an exclamation point (!), dollar sign ($), number sign (#), or Percent symbol (%).

    The password can be up to 128 characters long. The password used should be as long as possible and complex.

13. Select report Microsoft Options

15. Perform checks

17. Information Preview Confirmation

19. Start the formal installation

21. Installation Complete

23. Click Close to finish

25. Sql2008 in the Start menu

27. Open the Smse management tool

29. Open Administrative Tools

31. The new database option has a start PS option and is integrated into the sql2008

    New Database page has abandoned the sql7.0, only compatible with SQL Server 2000, the other is nothing big change

    After starting PS

    Create a new inbound rule in the firewall, port select 1433

    Established, able to work in the client, hehe.

SQL Server 2008 Installation diagram