Win10 Installing and uninstalling the SQL Server2008 database

I. Database installation Environment

Operating system: WIN10

SQL Server:sql Server R2

Two. New database installation 1. Install the extension file

Double-click the installation file to pop up the following form

WINDOW10 will pop up "This app doesn't work", so you don't have to process it.

Note: The steps that are not mentioned in this article, please click "Next" directly

2. Installation Wizard

After the extension file installation is complete, select Install –> New SQL Server Standalone installation or add features to an existing installation in the SQL Server2008 Installation Wizard

3. Installation program Support rules

SQL Server requires a "Setup support rule" Check prior to installation, and in the case of "figure 3-2" errors, see the "fourth installment summary" for the solution.

Figure 1 Check Success

Figure 2 Check Failure

4. Function selection

Select the database features that need to be installed, where SQL Server replication, Administrative Tools-Basic, SQL Client Connection SDK is required. the shared directory is the installation directory for Administrative Tools, SDKs, and so on.

5. Instance Configuration

Select named instance, enter a database instance name that is not in use, and set the root directory for the database instance installation.

Note: ① can install multiple DB instances under an instance root directory

② storage of MDF and LDF files under the Mssql\data directory in each DB instance directory

6.

Go to server configuration, click Use the same account for all SQL Server services, select NT Authority\System, and then click Next.

Go to "Reporting Services Configuration" and select the first item directly by default and click "Next".

Three. Adding functionality to Legacy databases

Four. Summary of installation issues

(Start-> Run->regedit) and locate the following path:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

Four. SQL Server Perfect Uninstall

Win10 Installing and uninstalling the SQL Server2008 database