|
1) Open up VMware
workstation 10.0
2)Locate your VMware
Windows 2012 R2 server
3) Right Click and
choose Settings
4) On the CD/DVD Drive
- under the Use ISO image file - change the destination to the SQL Server 2014
install. Choose "OK"
5) Log onto your
Windows Server 2012 R2 server
6) Click on the Folder
Icon on the Task Bar
7) Double Click on the DVD Drive
(D:) SQL2014_ENU_x64 
8) When the Prompt asks you for
UAC, click "Yes"
9) You will be presented with a
SQL Server Installation Center
10) Click on Installation
11) Choose "New SQL Server
stand-alone installation or add features to an existing installation
12) On the Next Screen, Enter
your Product Key, or Specify a free edition "Evaluation." Choose
Next.
13) Review the License terms.
Choose "I Accept the License Terms." Do not enable Customer
Experience Improvement Program. Choose "Next."
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."
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.
17) In this demonstration, Select
the "SQL Server Feature Installation." Choose "Next." once
completed.
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.
Click Next to continue.
19) Install .NET 3.5
Features.
20) Click on Server
Manager on your taskbar
21) Go to Manage on the
top right hand corner
22) Click on "Add
Roles and Features"
23) Review the Wizard
and Choose "Next."
24) On the next screen
choose, Role-Based or Feature-Based Installation and choose "Next."
25) Select a server
from the server pool and choose "Next."
26) Skip over the roles
on the selected server and choose "Next."
27) On the features
page, select .NET framework 3.5 features and choose "Next". Confirm
and Install the Framework.
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."
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."
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.
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.
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"
31)
Review the "Install" summary and choose "Install."
32) Verify
that SSMS is functional and that you can attach to the database engine -
VgaNetworkSQL\VgaNetworkSQL
|