Solar development Environment Configuration (i): SQL Server 2008R2

Environment configuration of solar energy development (I.)

Mainly includes the following content

• [x] 1. SQL Server 2008R2 Installation
• [x] 2. Verify that the installation is correct

1. SQL Server 2008R2 Installation

2. Double-click the Setup.exe file in the SQL R2 folder
   

4. Click [Install] on the left side of the interface, then click on the [New SQL Server Standalone installation or add features to an existing installation] on the right, and go to the SQL Server 2008 Setup Interface
   

6. First, [Setup support rules], after the operation is completed, click [OK].

8. Go to [Product Key], select the [Enter Product Key] option, enter the Product key MC46H-JQR3C-2JRHY-XYRKY-QWPVM, and click [Next].
   

10. Go to [License Terms] and tick [I accept the license terms] and click [Next] directly.

12. Go to [Installer support file], click [Install] button to start installing support files.
    

14. After the installation is complete, go to [Installer support rules], click [Show details] to see a detailed list of rules, click [Next].

16. Go to [Feature selection], choose [Select All], or select the function you want, and install the location by default. Click [Next].
    

18. Go to [instance configuration],[Default instance] and click [Next].
    

20. Go to [disk space requirement] and display the disk usage, you can click [Next] directly.

22. Go to [Server configuration]
    Account name
    SQL Server Agent \system
    SQL Server Analysis \net
    SQL Server Reporting \net
    SQL Server Integration \net
    SQL Server Database \net**

24. Go to Database engine configuration, click [Add Current User] to specify SQL Server administrator, Note: Select the hybrid login method. Once set, click Next.
    

26. Go to [Reporting Services Configuration] and select the first item directly by default and click [Next].
28. Go to [Error and Usage report], you can select one of them, send the relevant content to Mircosoft, or leave the selection, and then click [Next].
30. Go to [Install rules] and click [Next] directly.

32. Go to [Install Progress],sql Server 2008 Start the installation, do not care about it, wait for the installation to complete. When the installation is complete, it will list the specific features installed, prompting the installation process to complete, click [Next] to go to the [finish] screen and prompt [SQL Server 2008 installation completed successfully].

2. Verify that the installation is correct

1. Locate the SQL Server Management Studio shortcut, and double-click Open. If it does not open properly, it is recommended to reinstall. Uninstall, clear the registry.
   [Uninstall Method] {https://jingyan.baidu.com/article/a948d6517d95e50a2ccd2e4f.html}

2. Log in with "SQL Server Authentication", account: sa; Password: * * *;

3. After the connection is established, the Object Explorer---> Database and Right-click Append-Add to add the database file. (It is recommended that you move the database files used to "C:\Program files (x86) \microsoft SQL Server\mssql10_50.mssqlserver\mssql\data").

Solar development Environment Configuration (i): SQL Server 2008R2