Install SQL 2008 steps and the issues you encounter

Download URL: http://www.xiazaiba.com/html/4610.html

Installation steps:

1. After starting the Microsoft SQL 2008 Setup program in the Windows7 operating system, the System Compatibility Assistant will prompt the software for compatibility issues and must install the SP1 patch to run after the installation is complete, as shown in1-1. Here, select "Run Program" to start the installation of SQL Server 2008.

Note: The dialog box may appear (SQL Server Setup encountered the following error before creating a window handle and cannot invoke invoke or BeginInvoke on the control), as follows:

One possibility: To exit the installer, open the Task Manager (right-click on the taskbar), and see that there is still SQL service in the startup, close and then install.

Two possibilities: open Task Manager, end Mscorsvw.exe This process, and then install.

Three possibilities:. After an error occurs, locate the registry "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager" and PendingFileRenameOperations "value is deleted and then rerun the installation.

2. after entering the SQL Server Installation Center, skip the "plan" content, directly select "Install" in the list on the left side of the interface,1-2, enter the installation list selection.

3. Enter the SQL Server Installation Center -after the installation interface, the list on the right shows the different installation options. This article takes a fresh installation as an example to illustrate the entire installation process, so here's the first installation option, "New SQL Server standalone installation or existing installation add features."

4. After selecting the new installation, the System Program Compatibility Assistant again prompts for compatibility issues, asshown in 1-4. Select "Run Program" to continue the installation.

5. after entering the "Installer Support Rules" installation interface, the installer will automatically detect the installation Environment basic support situation, you need to ensure that all the conditions before the following installation, as shown. When all testing is complete, click "OK" to proceed with the installation below.

Note: The following conditions may occur at this time:

Solutions are:

A, restart the machine, and then install, if you find that the error, please follow the steps below:

B. Enter regedit in Start-to-run

C, to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager location

D, right-click on the right window pendingfilerenameoperations, select Delete, then confirm, quickly click Rerun

E, restart the installation, problem solving

Here's how to find the steps to start running:

Windows7 start is not "running", such as the red Oval space shown:

The following shows how to turn on the run feature, right-click the bottom-left "start" circle, and the word "properties" and "Open Windows Explorer" will appear: Open Properties--Start Menu tab--"Custom", for example: After opening "Custom" , find a "Run command" at the bottom with a small box, a √, select it.              Don't forget to be sure!! Finally look at the effect:In fact, the fastest and easiest way to use shortcut keys, press and hold the bottom line of the keyboard, the left alt next to the win logo key, and then press R, that is win+r, immediately open the "Run" command box. 6. Click Install

7. Next is the SQL Server2008 version selection and key filling, this articleintroduces "Enterprise Evaluation" as an example of the installation process, the key can be purchased from Microsoft Official, shown.

8. In the License Terms interface, you will need to accept the Microsoft Software License terms to install SQL Server2008,1-7 as shown.

Figure 1-7 License Terms

9. Next, install support prosecution, 1-8, click "Install" to continue the installation.

Figure 1-8 installation program support files

10.1-9, the following installation will not continue until all the tests have passed. If an error occurs, you need to correct any failures before installing.

Figure 1-9 installation program support rules

11. Through the "Installer support rules" after the prosecution to enter the "Functional Selection" interface, 1-10 shown. Here you select the SQL Server features you need to install and the installation path. Recommendation: Because data and operations log files can be particularly large, choose the installation path carefully, or choose a proprietary save path when creating a database.

Figure 1-10 Feature Selection

12.1-11, followed by "instance Configuration", where the default ID and path are selected.

Figure 1-11 Instance Configuration

13. After completing the installation Content selection, the disk usage is shown, which can be adjusted according to disk space, 1-12.

Figure 1-12 Disk Space requirements

14.1-13, in the server configuration, you need to specify a legitimate account for the various services. Note: This need to be based on the actual needs of users to make adjustments, this article does not delve into the impact of user settings, unified use of a user "Administrator", the resulting impact will be added in a later log.

Figure 1-13 Server Configuration

Note: First click on "Use same account for all SQL Server Services"
Then we will pop up a dialog box to let us enter the account and password: We click on the back of the Account drop-down list from the secondary school is any one of the accounts, where the password is not filled out, because it does not enter, we directly click "OK", this time will not be an error.

15. Next is the authentication at the time of the database logon, where you need to specify an administrator for SQL Server, as shown in the system administrator example, 1-14. Recommendation: When installing SQL Server on a server, it is safe to establish a separate user for this purpose. (select Add Current user)

Figure 1-14 Database Engine configuration

As shown in 16.1-15, specify an administrator for the Analysis Services configuration, as an example of the system administrator in this article. Recommendation: When installing SQL Server on a server, it is safe to establish a separate user for this purpose.

Figure 1-15 Analysis Services Configuration

17. Select the default mode in the Reporting Services configuration, and the user can choose according to the requirements, as shown in 1-16.

Figure 1-16 Reporting Services Configuration

As shown in 18.1-17, the Error and Usage report interface allows you to choose whether to send error reports to Microsoft.

Figure 1-17 Error and Usage report

19. Finally, according to the function configuration choose the environmental inspection again, 1-18 shows.

Figure 1-18 Installation Rules

20. When the prosecution is completed, the software will list all configuration information, the last confirmation of the installation, 1-19 shown. Click "Install" to start the SQL Server installation.

Figure 1-19 Preparing the installation

21. Depending on the hardware environment, the installation process may last for 10-30 minutes, as shown in 1-20.

Figure 1-20 Installation Progress

As shown in 22.1-21, when the installation is complete, SQL Server lists the feature installation states.

Figure 1-21 Installation Progress complete

As shown in 23.1-22, SQL Server 2008 completes the installation and saves the installation log under the specified path.

Install SQL 2008 steps and the issues you encounter