How to install Microsoft SQL Server 2014 on Windows Server 2012 R2 Platform: VMware workstation 10.

TECHIE >> Enterprise
6/26/2015 8:53:18 PM

 


 

1) Open up VMware workstation 10.0

 Image

2)Locate your VMware Windows 2012 R2 server

3) Right Click and choose Settings

 Image

4) On the CD/DVD Drive - under the Use ISO image file - change the destination to the SQL Server 2014 install. Choose "OK"

 Image

5) Log onto your Windows Server 2012 R2 server

6) Click on the Folder Icon on the Task Bar

 Image

7) Double Click on the DVD Drive (D:) SQL2014_ENU_x64

Image

8) When the Prompt asks you for UAC, click "Yes"

 Image

9) You will be presented with a SQL Server Installation Center

 Image

10) Click on Installation

 Image

11) Choose "New SQL Server stand-alone installation or add features to an existing installation

 Image

12) On the Next Screen, Enter your Product Key, or Specify a free edition "Evaluation." Choose Next.

 Image

13) Review the License terms. Choose "I Accept the License Terms." Do not enable Customer Experience Improvement Program. Choose "Next."

 Image

14) Check Global Rules

15) For now in this demonstration, skip over the Microsoft Windows updates for now. It is best practice for security vulnerabilities to keep your Microsoft patches up-to-date. Choose "Next."

 Image

16) Run the "Install Rules" wizard. Verify that all status are "Passed" or are warnings that are not applicable to the install. Choose "Next" once completed.

 Image

17) In this demonstration, Select the "SQL Server Feature Installation." Choose "Next." once completed.

 Image

18) On the Feature Selection, Install the following features

Instance Features:

Database Engine Services

SQL Server Replication

Full-Text and Semantic Extractions for Search

Data Quality Services

 

 

Shared Features:

Data Quality Client

Client Tools Connectivity

Integration Services

Client Tools Backwards Compatibility

Client Tools SDK

Management Tools - Basic

Management Tools - Complete

SQL Client Connectivity SDK

Master Data Services

 

In this Demo, we will also be changing the shared directory from the OS default to a standalone program files drive.

 Image

Click Next to continue.

 

19) Install .NET 3.5 Features.

 

20) Click on Server Manager on your taskbar

 Image

21) Go to Manage on the top right hand corner

 Image

22) Click on "Add Roles and Features"

 Image

 

23) Review the Wizard and Choose "Next."

 Image

 

24) On the next screen choose, Role-Based or Feature-Based Installation and choose "Next."

 Image

25) Select a server from the server pool and choose "Next."

 Image

 

26) Skip over the roles on the selected server and choose "Next."

 Image

 

27) On the features page, select .NET framework 3.5 features and choose "Next". Confirm and Install the Framework.

 Image

 

28) On the SQL Install, after the Feature Rules, you will be prompted with the Instance Configuration. Changed the Named Instance to your SQL Server name and choose "Next."

 Image

 

29) On the Server Configuration, you can change the account name to a service account. In this demonstration, the default will be kept. Choose "Next."

 Image

 

30) On the Database Engine Configuration, there will be three different configuration TABs - Server Configuration, Data Directories and FILESTREAM. On the Server Configuration modify the authentication mode to "Mixed Mode". Specify a SA account and document the SA account information in a password database. On the Specify SQL server administrators, add a group from active directory or users whom you'd like to be SQL server administrators. You should try to limit who has administrative access to a SQL Server.

 Image

On the Data Directories TAB, specify the drive letters for each directory. It is best practice to keep the Data, Log, and backup files separate.

 Image

Click on the FILESTREAM tab. Choose to Enable FILESTREAM for Transact-SQL Access, Enable FILESTREAM for file I/O access, and enable allow remote clients access to FILESTREAM data. Once completed, choose "next"

 Image

31) Review the "Install" summary and choose "Install."

 Image

 

32) Verify that SSMS is functional and that you can attach to the database engine - VgaNetworkSQL\VgaNetworkSQL

 Image

                                                                                                                       

 



Comments (0)

Page Views: 2692 Users: 3 IPs: 1274

Post a comment
Name:  
Email: (optional)
Comments: