SQL Server is a relational database management system launched by Microsoft. Microsoft SQL Server is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management. The Microsoft SQL Server database engine provides more secure and reliable storage functions for relational data and structured data, allowing you to build and manage highly available and high-performance data applications for business.
Two, installation and deployment
1. Download the SQL Server 2008 R2 database
extraction code: 3w3m
2.1. Decompress the downloaded SQL Server 2008 R2 installation file and double-click setup.exe.
2.2. Installation of SQL Server 2008 R2 requires .NET Framework 3.5 support.
2.3 Select the installation on the left, and then click the new SQL Server stand-alone installation on the right or add features to the existing installation.
2.4 Enter the product key, the next step:
2.5. Accept the license terms, next step, and then click install;
2.6. SQL Server function installation, select the required function and install it.
2.8. The default instance, the next step.
2.9. Service account settings, choose to use the same account for all SQL Server services.
Note: Please use the system account for the agent and engine, other nt service can be used; the database handle cannot be found
2.10 Authentication mode: Windows authentication mode, click "Add current user", next step.
2.11 Click "Install native mode default settings", the next step.
2.12 Select "Install", the next step.
2.13 Click Close and the installation is complete.
2.14 Click the start icon, find SQL Server Management Studio, and log in.