Microsoft SQL Server 2008 Basic Installation Instructions _mssql2008

The process of installing SQL2008 is basically the same as the SQL2005 program, except that some of the options are changed during installation, and of course, if only the comrades familiar with SQL2000 installation are a revolutionary change,

First, the preparation before installation
1. The. Net Framework 3.5 is required to require 3.5 SP1 support on Vista or higher OS (automatically updates the installation before SQL2008 is installed)
2. The need for Widnows PowerShell support, WPS is a very powerful shell application, command and dox/ UNIX-compatible and supports direct call to. NET modules for line command editing, a tool that is well worth further research (automatically updates the installation when SQL2008 is installed)
3. Need to ensure the successful start of Windows Installer requires more than 4.5 versions (need to check service startup status Service.msc)
4. Need MDAC2.8 SP1 support (integrated in XP system above)
5. If Visual Studio 2008 is installed on the machine, it will require support from the above version of VS 2008 SP1 (need to download and install http://www.microsoft.com/downloads/details.aspx from MS's Web site)? familyid=fbee1648-7106-44a7-9649-6d9f6d58056e&displaylang=en)

II. Installation and configuration process
1. For SQL Server Installation Center, select the "Install" option to install SQL2008 on a new computer to directly select "New SQL Server installed independently or to existing installation features", will install a default SQL real column, the following figure

2. Function selection, for the installation of only the database server, the choice of functions can be based on the actual work required to make, I General choice: Database Engine Services, client tool connections, SQL Server Books Online, management tools-BASIC, management tools-complete
Where the Database engine service is the core of the SQL database, the analysis and Reporting Services can be installed according to deployment requirements, and these two services may require the support of IIS. The following figure

3. Real column settings, you can directly select the default instance for installation, or if the same server has more than one data service real columns can be installed by different real column names. As shown in figure

4. Server configuration, the server configuration is mainly the service startup account configuration, service account name is recommended to use NT AUTHORITY\SYSTEM System account, and specify the current selection of service startup type, as shown

5. Database engine configuration, in the current configuration mainly set up SQL Login authentication mode and account password, and SQL data storage directory, authentication mode is recommended to use mixed mode for authentication, the built-in SQL Server system Administrator account (SA) password is more special, SQL2008 The password strength requirement for SA is relatively high and requires a combination of uppercase and lowercase letters, numbers, and symbols, otherwise you will not be allowed to continue the installation. It is a good idea to specify administrator administrators for this computer in the Specify SQL Server administrator. As shown in figure