Graphics and text detailed installation of SQL server2008_mssql2008 in Windows Server2012 R2

Start a Windows Server2012 cloud server, set up a service environment, choose SQL Server2008

Straight to the theme, the next good to install the mirror, directly double-click

Choose to run the program without getting help

As shown in figure:

Select Install and choose New Installation after entering the installation center

Also choose to run the program without getting help

Select the following figure:

The program will check the system, no warning, and so on the big problem can point to determine

Enter the product secret key, you can also choose the trial version; The trial version is simply not tolerated, I directly on the secret key, about the secret key I will give a solution at the bottom

Acceptance terms, Next

Point installation can

Software is tested again, without warning, you can click Next

Select the first item to

You can choose the function item according to your own requirement, I have ordered the whole selection here

Configuration file directory I chose the default

The important thing to do three times, is still no warning can click Next

The instance name, which is the name installed in the Windows service, is usually the default .

The directory of the instance is selected by default, and the next

Take a look at the disk space enough, enough, next

Service account: I choose to use the same account for the convenience of management

There are two choices, I choose System (System's permissions are higher than network service)

In general, select System

Startup Type I choose manually .

The following collation defaults to

To facilitate remote connections when necessary, typically select a mixed mode of authentication

Two times password to design a little more complex, safe

The following Select to add the current user

Data directory: According to their own needs to change (I choose the default)

FILESTREAM: Default on line

Next

Add Current User

Data directory: Press your own needs (I still default), next

General default on the line, next

Error Reporting: Look at your own situation, it doesn't matter.

Install configuration rules: The important thing to do four times, without warning continue on the line, next

ready to install: take a look no problem, install

Began to install, smoke a cigarette time is enough, the installation of the long to see the computer configuration, the server why look down to know

It's about 10 minutes away, (My broken notebook is about more than 20 minutes ...)

The installation is done, and the call is off.

Let's test it out.

====================== Test =======================

The local server name is lost. or 127.0.0.1.

Login name: SA

Local test OK

Remote test

Remote also has a problem with the meter

Attach some tips:

SQL Server service command line Quick Launch command:net start mssqlserver

Shutdown Service:net stop mssqlserver

The command opened by SQL Server Manager is:ssms

Wonderful topic Sharing: SQL Server Installation Tutorial manual

The article includes the detailed installation process, and finally with the test process, to provide you with some skills, I hope to help you learn.