Home  >  Article  >  Database  >  How to install SQL Server database?

How to install SQL Server database?

青灯夜游
青灯夜游Original
2019-05-16 14:21:5213990browse

How to install SQL Server database?

Installation steps of database SQL Server 2008

1. Download the sql server installation file from the Internet

2. Double-click sql Server 2008 .exe installation file, enter [SQL Server Installation Center].

How to install SQL Server database?

3. Select the installation option on the left and click the "New SQL Server independent installation or add features to an existing installation" option on the right, as shown in the figure:

How to install SQL Server database?

2-How to install SQL Server database?

4. In the opened "SQL Server 2008 Installer" dialog box, the [Installer Support Rules] interface appears, you can see , some checks have passed, click the OK button to enter the next step, as shown in the figure:

How to install SQL Server database?

5. After clicking the OK button, enter the product key. prompt, the key I use here is the enterprise version: "JD8Y6-HQG69-P9H84-XDTPG-34MBB", click the Next button to continue the installation, as shown in the picture:

How to install SQL Server database?

6. Select the "I accept the license terms" option on the next license terms page and click the Next button to continue the installation, as shown in the figure:

How to install SQL Server database?

7. In the "Installation Program Support Files" page that appears, click the Install button to continue, as shown in the figure:

How to install SQL Server database?

8. The process of installing program support files is as follows As shown in the picture:

How to install SQL Server database?

#9. After that, the "Installer Support Rules" page appears. Only if the rules are met can the installation continue. Click the Next button to continue the installation, as shown in the picture. Display:

How to install SQL Server database?

10. In the "Function Selection" page, click the Select All button and set the shared function directory, click Next to continue, as shown in the figure :

How to install SQL Server database?

11. In the "Instance Configuration" page, select the default instance and set the root directory of the instance. Click the Next button to continue, as shown in the figure:

How to install SQL Server database?

12. In the "Disk Space Requirements" page, the space required to install the software is displayed. Click Next to continue, as shown in the figure:

1How to install SQL Server database?

13. In the "Server Configuration" page, make settings as needed and click the Next button to continue the installation, as shown in the figure:

1How to install SQL Server database?

14. In the "Database Engine Configuration" page, set the authentication mode to mixed mode, enter the password of the database administrator, that is, the password of the sa user, and add the current user, click the Next button to continue the installation, such as As shown in the figure:

1How to install SQL Server database?

15. In the "Analysis Services Configuration" page, add the current user and click the Next button, as shown in the figure:

1How to install SQL Server database?

16. In the "Reporting Services Configuration" page, according to the default settings, click the Next button, as shown in the figure:

1How to install SQL Server database?

17. In the "Error and Usage Report" page, make selections according to your needs and click the Next button to continue the installation, as shown in the figure:

1How to install SQL Server database?

18. In the "Installation Rules" page, if everything passes, click the Next button to continue, as shown in the figure:

1How to install SQL Server database?

19. In the "Prepare to Install" page, you see the function options to be installed, click Next to continue the installation, as shown in the figure:

1How to install SQL Server database?

20. In the "Installation Progress" page, you can see that SQL Server 2008 is being installed, as shown in the figure:

1How to install SQL Server database?

21. After a long wait, the SQL Server 2008 installation process is completed. , there is no error now. My first error occurred in the step above. Click the Next button to continue, as shown in the picture:

How to install SQL Server database?

22. In the "Complete" page, you can see the prompt "SQL Server 2008 installation has been completed successfully". Click the Close button to end the installation, as shown in the figure:

2How to install SQL Server database?

23, Start SQL Server 2008, select SQL Server Configuration Manager under Microsoft SQL Server 2008 in the start menu, and start the SQL Server service, as shown in the figure:

2How to install SQL Server database?

22-How to install SQL Server database?

24. Finally, start the integration tool provided by Microsoft. Select the SQL Server Manager Studio option as shown in the picture above to open it. Enter the user name and password to enter, as shown in the picture:

2How to install SQL Server database?

23-How to install SQL Server database?

The above is the detailed content of How to install SQL Server database?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn