SQL Server 2008 Installation diagram

This article describes the hardware and software configuration requirements for installing SQL Server 2008 Enterprise Edition, the detailed steps for the installation process, and the things to be aware of.

Steps/Methods

2. 1

   Here we are going to illustrate the SQL Server 2008 installation and configuration process in a graphical way, in the hope of helping you.

4. 2

   Select version, or enter the key to automatically identify the version

6. 3

   License Agreement

8. 4

   Supporting file Installation

10. 5

    Installation complete starts checking itself

    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: Both SQL and local mode, enter password, add Administrator, can add local group or current user

    The password complexity policy prevents brute force attacks by increasing the number of possible passwords. When implementing the password complexity policy, the new password must conform to the following guidelines:

    The password must not contain 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.

    A password is at least eight characters long.

    The password contains 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. Use a password that is as long as possible and as complex.

13. Select report Microsoft Options

15. Run check

17. Information Preview Confirmation

19. Start a 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. New database options actually have the start PS option, integrated into sql2008

    New database page has been discarded sql7.0, only compatible with SQL Server 2000, the other is nothing big change

    After starting PS

    New inbound rule in firewall, port selection 1433

    set up to complete, you can work on the client, hehe.

    /span>