Installing SQL Server R2 Express on a Win7 64-bit PC

Installation Environment Description:

Operating system: Win7 64-bit English version

Installation steps:

1. Prepare the installation files

Download URL: https://www.microsoft.com/zh-CN/download/details.aspx?id=30438

1), Sqlexpr_x64_enu.ex

2), Sqlmanagementstudio_x64_enu.exe

2. Install some necessary components first

Online check, some said that need to install. Net Framwork3.5,iis, and so on, I am in the process of installation, but also follow this step.

3, first install Sqlexpr_x64_enu.exe

I am the selected file, right-click, as an administrator to install. Follow the default steps to install.

4, Installation Sqlmanagementstudio_x64_enu.exe

To install as an administrator, here are a few things to note:

Please select "New installation or add Shared Features", otherwise, there will be no management tool-basic, so there is no graphical interface

Follow the diagram and click "Next" to install.

5. SQL Server Managerment Studio appears in the Program menu, allowing you to graphically manage SQL Server

Lesson:

During the installation of the Sqlmanagementstudio_x64_enu.exe process, the initial selection led to an error in the installation, so that SQL Server could not be managed graphically, input services.msc from the command line, observe SQL Server services, The service is started normally. There is a problem installing here, if you first choose Add features to an existing instance of SQL Server R2, after installation error, then select New Installation or add shared Features, The management tools-basic does not appear, so, when installed, directly select New installation or add shared features to install.

This article, on the one hand, is given for later reference, on the other hand, also shared to other people in need.

Installing SQL Server R2 Express on a Win7 64-bit PC