Install SQL Server 2014 CTP2

Page updated :

Installing the .NET Framework 3.5

To use SQL Server 2014, you must pre-install the .NET Framework 3.5. Describes how to install .

Start Server Manager from the taskbar.

サーバー マネージャーを起動

From the Manage menu, select Add Roles and Features.

管理 - 役割と機能の追加

Click Next.


Make sure that role page or feature-based installation is checked, and then click Next.


Make sure that the target server is selected and click Next.


The role will not be installed, so just click Next.


Check .NET Framework 3.5 Features in feature selection. Leave the hierarchy of the children as they are.

.NET Framework 3.5 Features にチェック

Click the Install button. No reboot is needed.


Close the window when the installation is complete.


Installing SQL Server

Load the SQL Server 2014 DVD or virtual disk into the drive and start the installation. If it does not start automatically, double-click SQL Server on the DVD drive.

DVD ドライブ

Select Install from the left menu.


Click Perform a new stand-alone installation of SQL Server or add functionality to an existing installation.

SQL Server の新規スタンドアロン インストールを実行するか、既存のインストールに機能を追加します

Enter the product key, if any. If not, choose either Evaluation (limited-time full-time) or Express as a free edition.

プロダクト キーの入力

If you read the license terms carefully and agree to the license terms, you will be asked to "Accept the License Terms." check and click Next.


If the installation rule does not fail, click Next.

インストール ルール

If you are installing a database engine or Business Inteligence-related features, check Installsql Server Features. If you want to install powerpivot features, check SQL Server PowerPivot for SharePoint.

You have selected Install SQL Server Features.

セットアップ ロール

Check and install the following features:

Feature Name Description
Database Engine Services Check if you want to create a database on the target PC. You already have a database on another server, and you don't need to install only the tools to connect from the client PC.
SQL Server Replication It is a mechanism for synchronizing data with two or more SQL Servers.
Full-text search and semantic extraction for search Use for advanced text searches, such as searching for long text or words or phrases.
Data Quality Services This function enhances the information value of data by removing and correcting inaccurate data, such as cleansing data, extracting duplicate data, and matching with external data. It is mainly used in BUSINESS Intelligence (BI).
Analysis Services Used for multidimensional database construction, such as data analysis and cube generation. It's one of the BI features.
Reporting Services - Native Provides the ability to publish reports that you create on your TARGET PC on the Web.
Reporting Services - SharePoint Provides the ability to publish reports you create on SharePoint.
Reporting Services Add-in for SharePoint Products Contains components for running reporting service in SharePoint.
Data Quality Client Data Quality Services client tool.
Client Tool Connections Contains components for communication between the client and the server.
Integration Services It is a service that can perform various workflows such as data migration and data conversion from other databases.
Compatibility with previous versions of client tools Contains SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and Data Transformation Services (DTS).
Client Tools SDK Includes a software development kit that contains resources for programmers.
Document components The components that manage sql server documents are installed.
Administration Tools - Basics The ability to manage sql server features with tools. Includes basic functions such as working with the database engine. @SQL Server Management Studio
Management Tools - Full The ability to manage sql server features with tools. Includes all features. @SQL Server Management Studio
Distributed Playback Controller Contains a distributed playback controller that controls the actions of the distributed playback client.
Distributed Replay Client Contains distributed replay clients. Multiple distributed replay clients work together to simulate workloads for instances of SQL Server.
SQL Client Connection SDK Contains the SQL Server Native Client (ODBC/OLE DB) SDK for database application development.
Master Data Services It is a mechanism for integrating data from heterogeneous systems in an organization into a single master data source.

Here, we check database engine services and administrative tools - full. (The items that you checked will change the settings for the subsequent wizards.) )


Configure the instance. If you have more than one SQL Server (or multiple versions of SQL Server) installing an instance ID, you can specify which SQL Server to use for the instance ID.

If you want to install only one SQL Server on a PC, select Default Instance (only one SQL Server that can apply the default instance). If you want to install multiple SQL Servers or name for any reason, select Named Instances.

If you select Default Instance, the instance ID is MSSQLSERVER by default. You can change it, but use it as is except for special cases. If you want to use a named instance, specify any name.

We have selected Default Instances.


The service account sets up an account to start each service.

The started service runs with the permissions of the account that you started. Leave the default if there is no specific option for execution permissions.

The startup type allows you to specify whether to start automatically or manually when Windows starts.

Click the Next button to proceed, or select the Collation tab to change the collation.

サーバーの構成 - サービスアカウント

Collations allow you to specify what to do with string comparisons in the database. For example, case-insensitive, hiragana katakana, and so on. You can also change the way you distinguish by language.

Mainly specify a combination of the following distinctions:

Type of distinction The content of the distinction
CI Insensitive Case Case-insensitive. It is not case-sensitive. Example: "A" and "a" are the same
CS (Case Sensitive) Case-sensitive. Case sensitivity is also sensitive to the case of the full-width alphabet. CI reverse.
Accent Do not distinguish between accents, turbidity, or pop sounds. It does not distinguish between the turbid and the pop of the half-width kana. Examples: "Ha", "Ba", and "Pa" are the same
Accent Sensitive Distinguish between accents, turbidity, and pop sounds. AI reverse.
KS (Kana Sensitive) They distinguish between hiragana and katakana They distinguish even half-width Example: Distinguish between "ha" and "ha"
WS (Width Sensitive) Distinguish the width of the character. Distinguish between full-width and half-width. Example: Distinguish between "a" and "a"
BIN (Binary) Compare in binary. Distinguish everything.

If you want to make changes, please set it from the "Customize" button on the right.

サーバーの構成 - 照合順序

The following items appear when you install the Database Engine:

Configure servers to set up accounts to manage the Database Engine.

In authentication mode, you specify whether windows authentication is used only with SQL Server authentication and Windows authentication. If you use SQL Server authentication, enter the password required for the login because you will be assigned an "sa" account with administrative rights.

You must also set up at least one Windows account user who can log in and manage SQL Server. If you want to make the user currently logged in to Windows an administrator, click Add Current User. When you add it, the user is added to the list. If you want to add another user, add it from the Add button.

データベース エンジンの構成 - サーバーの構成 - SQL Server 管理者の指定 - 現在のユーザーの追加

Adding an administrator looks like the figure.

Click the Next button to proceed, or select each tab to change other settings.

データベース エンジンの構成 - サーバーの構成 - SQL Server 管理者の指定

If you want to change the directory you want to install, select the Data Directory tab and change each one.

データベース エンジンの構成 - データ ディレクトリ

If you want to work with files on the database, you can use FILESTREAM. If you are using FILESTREAM, enable each item as needed.

データベース エンジンの構成 - FILESTREAM

If you are sure what you want to install and you are ok, click Install.


When the installation is complete, click Close to close the screen. If the previous screen remains, close it as well.


Check operation

Start by selecting "SQL Server Management Studio" from the Start menu.

スタートメニュー - SQL Server Management Studio

A connection dialog to the server appears, which connects with Windows authentication. (If you specified an instance name when you created the database, add "<instance name>" after the server name.) )


It is OK if it is possible to connect without an error.