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

Source: Internet
Author: User
Tags microsoft sql server disk usage management studio sql server management sql server management studio

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
  1. Double-click the Setup.exe file in the SQL R2 folder

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

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

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

  5. Go to [License Terms] and tick [I accept the license terms] and click [Next] directly.
  6. Go to [Installer support file], click [Install] button to start installing support files.

  7. After the installation is complete, go to [Installer support rules], click [Show details] to see a detailed list of rules, click [Next].
  8. Go to [Feature selection], choose [Select All], or select the function you want, and install the location by default. Click [Next].

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

  10. Go to [disk space requirement] and display the disk usage, you can click [Next] directly.
  11. 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**

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

  13. Go to [Reporting Services Configuration] and select the first item directly by default and click [Next].
  14. 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].
  15. Go to [Install rules] and click [Next] directly.
  16. 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.