Thursday, March 17, 2016

SQL server 2014 Installation and Configuration on Oracle VM or Virtual Machine or Stand alone

Machine generated alternative text:
File 
Copy 
Machine View Input 
Home 
Share 
Copy path 
Paste 
Paste shortcut 
Devices 
View 
Move 
to • 
Help 
Copy 
Delete 
Organize 
Rename 
RavishankerMaduri 
New item 
Easy access 
New 
folder 
Clipboard 
T 
Favo rites 
Desktop 
Downloads 
Recent places 
This pc 
Desktop 
Documents 
Music 
Pictures 
Videos 
This pc 
Local Disk 
TEMP 
Q 
Name 
e 
SQLServer2014SP1- 
Disc Image File 
-ENU 
Notepad 
Properties 
Open 
Date modified 
3/6/2016 4:58 PM 
3/17/2016 7:20 AM 
Select all 
o Select none 
Invert selection 
Select 
Type 
Disc Image File 
Disc Image File 
Size 
Ful[SIipstream-x64 
Local Disk 
CD Drive (D:) Virtual 
RavishankerMaduri 
DVD Drive SQL2(


Download the Software and copy to some local folder which has full permissions on the folder on your logged or installing account


Make sure Firewall Is Off

Machine generated alternative text:
File Action View Help 
Windows Firewall with Advanct 
Inbound Rules 
Outbound Rules 
Connection Security Rules 
Monitoring 
Firewall 
Connection Security Ru 
Security Associations 
Windows Firewall with Advanced Security 
RavishankerMaduri Notepad 
Monitoring 
Private Profile is Active 
Wndows firewall is off 
hbound connections that do not match a rule are blocked 
Outbound connections that do not match a rule are allowed 
Display a notification when a program is blocked 
Apply local firewall rules 
Apply local connection security rules 
File name: 
File maximum size (KB) 
Log dropped packete 
Ing successful connections 
om 
View 
Refresh 
Help 
em root% 
em32\Lo Filas\firawall

Machine generated alternative text:
SQL Server 2014 setup 
Database Engine Configuration 
Specify Database Engine authentication security mode, administrators and data directories. 
onitorir 
Priva 
Display 
Apply 
File na 
Log d 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Server Configuration Data Directories FILESTREAM 
Specify the authentication mode and administrators for the Database Engine. 
Authentication Mode 
C) Windows authentication mode 
@ Mixed Mode (SQL Server authentication and Windows authentication) 
Specify the password for the SQL Server system administrator (sa) account. 
Enter password: 
Confirm password: 
Specify SQL Server administrators 
VAN-LIECH824PIG\Administretcr •éciminiGtretcrg 
Add Current user 
Back 
Next > 
SQL Server ad 
have unrestri 
to the Data 
Cancel


Machine generated alternative text:
SQL Server 2014 setup 
Database Engine Configuration 
Specify Database Engine authentication security mode, administrators and data directories. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Server Configuration Data Directories FILESTREAM 
Data root directory: 
System database directory: 
user database directory: 
user database log directory: 
Temp DB directory: 
Temp DB log directory: 
Backup directory: 
Files\Microsoft SQL Server\ 
Files\Microsoft SQL 
FilesWicrosoft SQL ServerWSSQL12.MSSQLSERVER: 
FilesWicrosoft SQL ServerWSSQL12.MSSQLSERVER: 
FilesWicrosoft SQL ServerWSSQL12.MSSQLSERVER: 
FilesWicrosoft SQL ServerWSSQL12.MSSQLSERVER: 
FilesWicrosoft SQL ServerWSSQL12.MSSQLSERVER: 
Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Database Engine Configuration 
Specify Database Engine authentication security mode, administrators and data directories. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
FILESTREAM 
Server Configuration Data Directories 
[e] Enable FILESTREAM for Transact-SQL access 
[e] Enable FILESTREAM for file I/O access 
W,ndows share name: MSSQLSERVER2014 
[e] Allow [emote clients access to FILESTREAM data 
< Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Analysis Services Configuration 
Specify Analysis Services server modes, administrators, and data directories. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Server Configuration Data Directories 
Server Mode: 
@ Multidimensional and Data Mining Mode 
C) Tabular Mode 
Specify which users have administrative permissions for Analysis Services. 
VAN-LIECH824PIG\Administretcr •éciminiGtretcrg 
Add Current user 
Analysis Services 
administrators have 
unrestricted access to 
Analysis Services. 
Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Analysis Services Configuration 
Specify Analysis Services server modes, administrators, and data directories. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Server Configuration Data Directories 
Specify the data directories for SQL Server Analysis Services. 
Data directory: 
Log file directory: 
Temp directory: 
Backup directory: 
FilesWicrosoft SQL 
FilesWicrosoft SQL 
FilesWicrosoft SQL 
FilesWicrosoft SQL 
Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Reporting Services Configuration 
Specify the Reporting Services configuration mode. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuram 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Reporting Services Native Mode 
C) Install and configure. 
Installs and configures the repot sever in native mode. The report server is operational after 
setup completes. 
@ Install only. 
Installs the report server files. After installation, use Reporting Services Configuration Manager 
to configure the repot sewer for native mode. 
Reporting Services SharePoint Integrated Mode 
@ Install only. 
Installs the report server files. After installation use SharePoint Central Administration to 
complete the configuration. Verify the SQL Server Reporting Services service is stated and 
create at least one SQL Server Reporting Services service application. For more information, 
click Help. 
Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Distributed Replay Controller 
Specify Distributed Replay Controller service access permissions. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Specify which users have permissions for the Distributed Replay Controller service. 
(Administratcr) 
Back 
Users that have been 
granted permission will have 
unlimited access to the 
Distributed Replay 
Controller service. 
Add Current user 
Next > 
Cancel 
Help

Machine generated alternative text:
SQL Server 2014 setup 
Distributed Replay Client 
Specify the corresponding controller and data directories for the Distributed Replay Client. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Specify controller machine name and directory locations. 
Controller Name: 
Working Directory: 
Result Directory: 
MSSQLSERVER2014 
Files SQL 
Files SQL 
Back 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Feature Configuration Rules 
Setup is running rules to determine if the installation process will be blocked. For more information, click Help. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Operation completed. Passed: 7. Failed O. Warning O. Skipped O. 
Hide details < < 
View detailed repot 
Rule 
FAT32 File System 
'Sting clustered or cluster-prepared instance 
Cross language installation 
Same architecture installation 
orting Services Catalog Database File Existence 
orting Services Catalog Temporary Database File Existence 
SQL Server Analysis Services Server Mode and Edition Check 
Back 
Next > 
Status 
Passed 
Passed 
Passed 
Passed 
Passed 
Passed 
Passed 
Cancel 
Re- run 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Ready to Install 
Verify the SQL Server 2014 features to be installed. 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Ready to install SQL Server 2014: 
Summary 
Edition: Evaluation 
Action: Install (Product Update) 
- Prerequisites 
[S Already installed: 
Windows PowerSheII 2.0 
Microsoft .NET Framework 3.5 
Microsoft .NET Framework 4.0 
To be installed from media: 
Microsoft Visual Studio 2010 Redistributables 
Microsoft Visual Studio 2010 Shell 
Microsoft Visual Studio Tools for Applications 3.0 
- General Configuration 
[4 Features 
Database Engine Services 
SQL Server Replication 
Full-Text and Semantic Extractions for Search 
Configuration file path: 
Files\Microsoft SQL 
Back 
Install 
Cancel 
Help

Make sure you have enough space

Machine generated alternative text:
File Machine View Input Devices 
File Action View Help 
Help 
Computer Management 
RavishankerMaduri Notepad 
Local Disk (C:) Properties 
Computer Management (Local 
System Tools 
Task Scheduler 
Event Viewer 
Shared Folders 
Local Users and Groups 
(S) Perf 
ormance 
Device Manager 
Storage 
Windows Server 8ackuF: 
Disk Management 
Services and Applications 
Internet Information Sel 
Routing and Remote Ac 
Services 
WMI Control 
SQL Server Configuratic 
Message Queuing 
Volume 
SQL2014_x64 ENU 
4V80XADDITIONS 5. 
out 
Simple 
Simple 
Simple 
Basic 
Basic 
Basic 
File 
NTFS 
CDFS 
CDFS 
em Status 
Healthy (System, Boot, Page Fil 
Healthy (Primary Partition) 
Healthy (Primary Partition) 
Shadow Copies 
Sharing 
Quota 
Disk O 
Basic 
100.00 
Online 
CD-ROM O 
CD-ROM 
57 MB 
Online 
5000 G8 NTFS 
Healt (System, 8 oat, Pa 
VBOXADDlTlONS_5. 
57 MB CDFS 
Healthy (Primary Partition) 
e File, Active, ( 
SODO 
Unallocated 
CD-ROM I 
Unallocated Primary partition 
Status Disk quota system is active 
Enable quota management 
Deny disk space to users exceeding quota 
Select the defauH quota for new users on this volume 
@ Do not disk usage 
C) Limit disk space to 
Set naming level to 
Select the quota Bgging options for this volume 
Ing event when a user exceeds their quota limit 
Ing event when a user exceeds their warning level 
Quota Entries„ 
*ppb'


Machine generated alternative text:
Planning 
Maintenance 
Tools 
Resources 
Advanc ed 
Options 
Microsoft SQL Server2014 
Installation Progress 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
SQL Server 2014 setup 
Install VSSheII Cpu32 Action 
RavishankerMaduri 
Notepad 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Installation Progress 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Install_rsSharePoint Cpu64_Action 
RegisterProduct. Registering product 
Next > 
Cancel 
Help


Machine generated alternative text:
SQL Server 2014 setup 
Planning 
Maintenance 
Tools 
Resources 
Adva nced 
Options 
Microsoft SQL Server2014 
Complete 
YourSQL Server 2014 installation completed successfully with product updates. 
RavishankerMaduri 
Notepad 
Product Key 
License Terms 
Global Rules 
Microsoft Update 
Product Updates 
Install Setup Files 
Install Rules 
Setup Role 
Feature Selection 
Feature Rules 
Instance Configuration 
Server Configuration 
Database Engine Configuration 
Analysis Services Configuration 
Reporting Services Configuration 
Distributed Replay Controller 
Distributed Replay Client 
Feature Configuration Rules 
Ready to Install 
Information about the Setup operation or possible next steps: 
Feature 
SQL Browser 
Documentation Components 
SQL Writer 
SQL Client Connectivity 
SQL Client Connectivity SDK 
Setup Support Files 
Details: 
Viewing Product Documentation for SQL Server 
Status 
Succeeded 
Succeeded 
Succeeded 
Succeeded 
Succeeded 
Succeeded 
Only the components that you use to view and manage the documentation for SQL Sarver have been 
installed. ay default, the Help Viewer component uses the online library. After installing SQL Server, 
can use the Help Library Manager component to download documentation to your local computer. 
For more information, see Use Microsoft Books Online for SQL Server 
<htt :/,' 
Summary log file has been saved to the following location: 
FilesWicrosoft SQL 0806591Summa0' WIN 
LICDH324PIG 20160317 080659.txt 
Close 
Help

No comments: