[0414] SQL Server R2 Installation & Setup

SQL Server R2 installation & Setup SQL Server Installation

• Installation Environment: Windows 10 1709 64-bit
• installation files:
  • SQL Server R2
  • SQL Server Compact Edition
  • SQL Server Management Studio
• In general, with the first installation, the download of SQL Server Lite requires the installation of SQL Server Management Studio with
• installation process
• Please follow the installation process Strictly!

SQL Server Local Database configuration

• Open it:
• The protocol for the 2008r2:sqlserver network configuration-mssqlserver is installed, and all protocols are started.
  
• A lite version is installed: The SQL Server Network configuration-sqlexpress protocol that starts all protocols.
  
• Right-click the TCP/IP protocol, open properties
  
• Locate the column with the IP address 127.0.0.1 , change the port to 1433, and change the start to Yes
  
• Open the SQL Server service-sqlserver (your instance, R2 to mssqlserver,2008 for SQLExpress)-reboot
  
• If you are installing SQL Server R2, open SQL Server Management Studio and connect using the following configuration
  
• If you are installing SQL Server Lite , open SQL Server Management Studio and connect using the following configuration
  

Welfare

• Gu Yuanhua test Report content normalization generated, the code to be converted to the Clipboard, open the program, press the button, back to the Word document, using CTRL + V to copy, see the following:
  
• Source code & Compiled version: Link: https://pan.baidu.com/s/16hy3JxS6tw23wj-k4VSu4g Password: GBTB

[0414] SQL Server R2 Installation & Setup