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].

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:

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:

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:

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:

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

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

#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:

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 :

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:

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:

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

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:

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

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

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:

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

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:

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

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:

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:

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:

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:

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!