Installing and configuring SQL Server 2014

Installing and configuring SQL Server

Prepare:

1. SQL Server 2014 is required for. NET Framework 3.5.1 Support, click on "Server Manager", select "Features", and select "Add Features" on the right.

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M01/59/FA/wKioL1TxmwryhciVAACfhQxXYlM977.jpg "border=" 0 "height=" 294 "/ >

2. Select the ". NET Framework 3.5.1 Features" property to install.

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image004 "src=" http://s3.51cto.com/wyfs02/M02/59/FA/wKioL1Txmwuzdd3mAAD4WKijCYE802.jpg "border=" 0 "height=" 215 "/ >

Install SQL Server :

1. Download the 64-bit SQL Server 2014 English Enterprise installation package: En_sql_server_2014_enterprise_edition_x64_dvd_<xxxxxxx>.iso

2. After unzipping or mounting with a virtual optical drive, click setup.exe

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image006 "src=" http://s3.51cto.com/wyfs02/M00/59/FA/wKioL1TxmwvCfRKWAACcMhP-dRQ446.jpg "border=" 0 "height=" 366 "/ >

3. In the "Installation" menu, select "New SQL Server stand-alone installation or add features to an existing installation"

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image008 "src=" http://s3.51cto.com/wyfs02/M01/59/FA/wKioL1TxmwziLAEkAADyO51sZPY925.jpg "border=" 0 "height=" 211 "/ >

4. Select Next until the "Installation Type" menu and select "Perform a new installation of SQL Server 2014".

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image010 "src=" http://s3.51cto.com/wyfs02/M02/59/FA/wKioL1Txmw3z5iQ7AADxVgw9Z4c579.jpg "border=" 0 "height=" 201 "/ >

5. Select Next, until the Setup Role menu, select SQL Server Feature installation.

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image012 "src=" http://s3.51cto.com/wyfs02/M00/59/FB/wKioL1Txmw6RwyU-AAEpM-_VGdI996.jpg "border=" 0 "height=" 269 "/ >

6. Select Next, in the "Feature Selection" menu, select the properties to install and set the root directory of the instance installation.

7. Select Next, and on the Instance Configuration menu, select Default Instance.

8. Select Next, on the Server Configuration menu, set the startup account and startup type for each of the installed services, and select the collation. The author here set up SQL Server startup account for the Account Domain\sqlservice,sql Server Agent with the startup account Domain\sqlagent, are automatically started. The charset is set to Chinese_prc_ci_as.

9. Select Next, in the "Database Engine cofiguration" menu:

A) Configure the "Server Configuration" to "Mixed Mode" and enter the password for the SA. Add the SQL Server administrator account.

b) Configure the "Data Directories" to set the directory for the files to be installed.

c) Configure whether "FILESTREAM" is enabled.

10. If there is an installation analysis service, it will be in the Analyze Services Configuration menu:

A) Configure "server Configuration" to configure the server mode for cube and Data Warehouse mode or tabular mode. Add an administrator account for the analytics service.

b) Configure the "Data Directories" to set the directory for the Analysis service's database files.

11. If you have a reporting service installed, you will select it in the Reporting Services Configuration menu based on the mode of Reporting Services installed.

12. After the configuration is complete, the configuration output is displayed in the Ready to Install menu.

13. Click Install to display the progress of the installation in the "Installation Progress" menu.

14. After installation, on the "Complete" menu, display the installed components and services.

15. Close the installation window.

Configure SQL Server :

1. "Start | Run ", enter Secpol.msc.

650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image014 "src=" http://s3.51cto.com/wyfs02/M00/59/FE/wKiom1TxmgCz77FjAACTBQaVibw883.jpg "border=" 0 "height=" 202 "/ >

2. In the "Local Security Policy" window, select "Local Policies | User rights Assignment ", on the right of" Lock pages in Memory "and" Perform Volume maintenance Tasks ", add the startup account for SQL Server Database.

3. Create the Data directory sql-data, log directory Sql-log, and backup file directory Sql-backup, respectively.

4. Grant the SQL Server startup account, SQL Server Agent startup account, database backup account, and so on, to read and write access to these directories.

5. Open SSMs 2014 and connect to the installed instance.

650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image016 "src=" http://s3.51cto.com/wyfs02/M01/59/FE/wKiom1TxmgCz9JYAAADhoOWQyhI830.jpg "border=" 0 "height=" 308 "/ >

6. On the instance node of the "Object Explorer", right-select "Properties".

650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image018 "src=" http://s3.51cto.com/wyfs02/M02/59/FE/wKiom1TxmgGTHiNGAAD6pgWK1jc125.jpg "border=" 0 "height=" 463 "/ >

7. In the "Memory" menu, set the maximum memory size, reserve some memory for the operating system and other applications.

650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image020 "src=" http://s3.51cto.com/wyfs02/M00/59/FE/wKiom1TxmgKTwCCeAADKZkvtCyI241.jpg "border=" 0 "height=" 255 "/ >

8. On the Database Settings menu, set whether to turn on the default path for compressed backup, data, log, and backup files.

To install SSDT :

1. Download the. NET Framework 4.5.1 (offline installer) and download the. NET Framework 4.5.1 Language Pack on Demand (offline installer)
http://support.microsoft.com/kb/2858728/

2. Install the. NET Framework 4.5.1.

3. Download Microsoft SQL Server Data tools–business Intelligence for Visual Studio 2013.
http://www.microsoft.com/en-us/download/details.aspx?id=42313

4. Install SSDT, which is compatible with 32-bit and 64-bit, but if you have installed the 64-bit version of SQL Server, you must select "new instance" for installation, otherwise you will be reported a "the CPU architecture of installing Feature (s) is different than the instance specified. To continue, add features to this instance with the same architecture "error and cannot be installed.

650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image022 "src=" Http://s3.51cto.com/wyfs02/M01/59/FE/wKiom1TxmgPw2xnPAAFUm6oX9x8558.jpg "border=" 0 "height=" 375 "/>

Summary of issues:

1. The SSIS package that is designed in SQL Server 2008/2008 R2 calls the "OLE DB provider" version of "SQLNCLI10.1" to SQL Server 2012/2014 and needs to be modified in the SSIS package "Connection The version of the "String" section is "SQLNCLI11". If you do not modify it, the following error will occur:
   
   Error:the requested OLE DB provider SQLNCLI10.1 are not registered.if the 32-bit driver are not installed,run the package in 64-bit mode. Error code:0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult:
   0x80040154 Description: "Class not registered".
   Error:consider changing the PROVIDER in the connection string to SQLNCLI11 or visit http://www.microsoft.com/downloads to Find and install support for SQLNCLI10.1.
   
   

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1616054

Installing and configuring SQL Server 2014