Share one time installing SQL Server2008 in Windows Server2012 R2

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

Go straight to the subject, right after you install the image, double-click

Choose to run the program without getting help

Select Install and select New installation after entering the installation center

Also choose to run the program without getting help

After selection

The program will check the system, no warning and other big problems can be determined.

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

Accept the terms, next

Point installation can

The software detects it again, and without warning, you can click Next.

Select the first item to

You can choose the function item according to your own demand, I have ordered a full selection here

Configuration file directory I chose the default

Important things to do three times, still without 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 convenient management

Two choices appear, I select System (System has higher permissions than network Service)

In general, select System

Startup Type I chose to do it manually.

The following collation defaults to

In order to facilitate remote connection when necessary, general Select the mixed mode of authentication

Two passwords to design a little more complex, safe

Select Add Current user below

Data Catalog: Change to your own needs (I choose the default)

FILESTREAM: Default is OK

Next

Add Current User

Data Catalog: Press your own needs (I still default)

Next

General default on the line

Next

Error Reporting: It doesn't matter if you look at your situation

Installation configuration rules: The important thing to do four times, no warning to continue on the line

Next

Ready to install: look no problem,

Installation

Start the installation, the time to smoke a cigarette is enough, the installation time will look at the computer configuration, the server well look down to know

It's probably less than 10 minutes, (My broken notebook was loaded for about more than 20 minutes ...)

The installation is complete and the call is closed.

Let's test it down.

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

The local server name is lost. or 127.0.0.1.

Login name: SA

Local test OK

Test it remotely.

Remote also rice has a problem

Attach some tips:

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

Close service: net stop mssqlserver

The command opened by SQL Server Manager is: SSMs

Https://www.cnblogs.com/AIThink/p/4902889.html

Share one time installing SQL Server2008 in Windows Server2012 R2