Install SQL Server 2014 CTP2
Installing the .NET Framework 3.5
To use SQL Server 2014 you must pre-install the .NET Framework 3.5. NET Framework installation is not related to SQL Server and is not discussed in detail, but this section describes how to install the .NET Framework 3.5 on Windows Server 2012 R2.
Start Server Manager from the taskbar.
Select Add Roles and Features from Manage menu.
Click Next.
Ensure that Role-Page or Feature-Based Installation is checked, and then click Next.
Ensure that the target server is selected and click Next.
Since the role is not installed, click "Next" as it is.
In the selection of features ". NET Framework 3.5 Features. Leave the hierarchy of the children as they are.
Click the Install button. No reboot is required.
Close the window when the installation is complete.
Installing SQL Server
Insert 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.
Select Install from the menu on the left.
Click Perform a new stand-alone installation of SQL Server or add features to an existing installation.
Enter your product key, if you have one. If not, select either "Evaluation (full for a limited time only)" or "Express" as the free edition.
Read the license terms carefully, and if you agree to the license terms, check I accept the license terms, and then click Next.
If the installation rule does not fail, click Next.
If you want to install the database engine or Business Inteligence-related features, check Install SQL Server Features. To install the PowerPivot feature, check SQL Server PowerPivot for SharePoint.
Here we select Install SQL Server features.
Check the following features to install and install.
| function namesdescription | |
|---|---|
| Database Engine Services | If you want to create a database on the target PC, check it. You do not need to have the database already on a separate server and 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 to perform advanced text searches, such as long text or word-by-word searches. |
| Data Quality Services | It is a function to increase the information value of data by removing and correcting inaccurate data, such as data cleansing, extraction of duplicate data, and matching with external data. It is mainly used in BI (Business Intelligence) related. |
| Analysis Services | It is used for multidimensional database construction such as data analysis and cube generation. It is one of the BI features. |
| Reporting Services - Native | Provides the ability to publish reports created on the target PC to the Web. |
| Reporting Services - SharePoint | Provides the ability to publish the reports that you create on SharePoint. |
| Reporting Services add-ins for SharePoint Products | Contains components for running Reporting Service within SharePoint. |
| Data Quality Client | A client tool for Data Quality Services. |
| Client Tool Connections | Contains components for communication between the client and the server. |
| Integration Services | It is a service that can execute various workflows such as data migration and data conversion from other databases. |
| Compatibility with older versions of client tools | Includes SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSOs), and Data Transformation Services (DTS). |
| Client Tools SDK | Includes a software development kit with resources for programmers. |
| Document Components | The components that manage SQL Server documentation are installed. |
| Administrative Tools – Basics | A feature for managing SQL Server features with tools. It includes basic functions such as working with the database engine. (SQL Server Management Studio) |
| Administrative Tools – Complete | A feature for managing SQL Server features with tools. All features are included. (SQL Server Management Studio) |
| Distributed playback controller | Contains a Distributed Replay controller that governs the actions of the Distributed Replay client. |
| Distributed Replay Client | Includes distributed replay clients. Multiple Distributed Replay clients work together to simulate workloads for instances of SQL Server. |
| SQL Client Connectivity SDK | Includes the SQL Server Native Client (ODBC/OLE DB) SDK for database application development. |
| Master Data Services | A mechanism for consolidating data from heterogeneous systems in an organization into a single master data source. |
We check Database Engine Service and Administrative Tools - Complete. (The items you check will change the settings of the wizard from now on.) )
Configure the instance. The instance ID allows you to specify which SQL Server to use with the instance ID if you are installing multiple SQL Servers (or multiple versions of SQL Server) on a single unit.
Select Default Instance if you want to install only one SQL Server per PC (only one SQL Server can be applied to the default instance). If you are installing multiple SQL Servers, or if you want to name them for any reason, choose Named Instances.
If you select Default Instance, the instance ID defaults to MSSQLSERVER. You can change it, but you should use it as is unless there are special cases. If you want to use a named instance, specify any name.
Here we have selected "Default Instance".
The service account sets up an account to start each service.
The launched service runs with the privileges of the account that started it. Leave the default if you do not specify any specific execute permissions.
You can specify whether the startup type starts automatically or manually when Windows starts.
Click the Next button to continue, or select the Collation tab to change the collation.
Collations allow you to specify how string comparisons are handled in the database. For example, not case sensitive, not distinguishing hiragana katakana, and so on. You can also make different distinctions depending on the language.
It is mainly a combination of the following distinctions:
DistinctionsContents of| Types of | the Distinctions |
|---|---|
| CI (Case Insensitive) | Not case-sensitive. It is also not case-sensitive to the full-width alphabet. Example: "A" and "a" are the same |
| CS (Case Sensitive) | Case-sensitive. It is also case-sensitive to the full-width alphabet. The reverse of CI. |
| AI (Accent Insensitive) | Do not distinguish between accents, turbidities, and plosives. It also does not distinguish between half-width kana turbidity and plosives. Example: "Ha", "Ba", "Pa" are the same |
| AS (Accent Sensitive) | Distinguish accents, turbidities, plosives. The reverse of AI. |
| KS (Kana Sensitive) | Distinguish between hiragana and katakana. Distinguish even in half-width. Example: Distinguish between "ha" and "ha" |
| WS (Width Sensitive) | Distinguish character widths. 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 the server to set up the account that manages the Database Engine.
Specifies whether authentication mode uses Windows authentication only or SQL Server authentication and Windows authentication. If you use SQL Server authentication, you will be assigned an "sa" account with administrator privileges and enter the password required to log in.
You must also configure at least one Windows account user who can log in to and manage SQL Server. If you want the user who is currently logged in to Windows to be an administrator, click Add Current User. Adding adds the user to the list. If you want to add other users, please add them from the "Add" button.
When you add an administrator, it looks like the picture.
Click the "Next" button to continue, or select each tab to change other settings.
If you want to change the directory to be installed, select the "Data Directory" tab and change each one.
If you want to handle files on a database, you can use "FILESTREAM". When using FILESTREAM, enable each item as necessary.
If you are satisfied with the contents to be installed, click "Install".
When the installation is complete, click Close to close the screen. If the previous screen remains, please close it as well.
Operation check
Start SQL Server Management Studio from the Start menu.
The Connect to Server dialog is displayed, so connect with Windows Authentication. (If you specified an instance name when creating the database, add "
If you can connect without errors, it is OK.