Step 1
| Mount the
Microsoft SQL Server 2014 ISO image to the virtual machine. For more
information, see
Mount and Unmount ISO Files.
|
Step 2
| Run setup.exe.
|
Step 3
| Click
Installation on the left pane and then click
New
SQL Server stand-alone installation or add features to an existing
installation link.
The SQL Server
2014 Setup wizard opens. Click
Next.
|
Step 4
| Accept the
Licence Terms and click
Next.
|
Step 5
| On
Microsoft Update page, click
Next.
|
Step 6
| On
Product
Updates page, click
Next.
|
Step 7
| On
Install
Rules page, click
Next.
|
Step 8
| On
Setup
Role page, select
SQL
Server Feature Installation, and click
Next.
|
Step 9
| On
Feature
Selection page, choose all the features except below:
- Analysis
Services
- Reporting
Services-Native
- Reporting Services -
SharePoint
- Reporting Services Add-in
for SharePoint Products
- Distributed Replay
Controller
- Distributed Replay
Client
Click
Next.
|
Step 10
| On
Instance Configuration page, select
Default Instance. Click
Next.
|
Step 11
| On
Server
Configuration page, click
Services Account tab:
You must
associate the SQL Services with the Account Name.
-
For SQL
Server Database Engine, choose
NT Service\MSSQLSERVER from
Account Name drop-down list and choose
Automatic in
Startup Type column.
-
For SQL
Server Agent, choose
NT Service\SQLSERVERAGENT from
Account Name drop-down list and choose
Automatic in
Startup Type column.
-
For the
remaining services, accept the default values.
|
Step 12
| On
Server
Configuration page, select
Collation tab.
Note
|
Collation
configuration is different for both CCE and CCDM servers. Follow the
appropriate procedures to configure collation.
|
|
Step 13
| On the
Database Engine Configuration page, perform the
following:
- In
Server Configuration tab, choose
Mixed Mode option.
- Enter
your password and confirm by reentering it.
- Click
Add Current User.
- Select
Data Directories tab, it is strongly recommended that
Temp DB and
Temp DB log directories should be in different
drives.
- Click
Next.
|
Step 14
| Click
Install on the
Ready
to Install page.
|
Step 15
| Click
Close on the
Complete page.
|
Step 16
| Enable Named
Pipes and set the sort order as follows:
- Open
SQL Server 2014 Configuration Manager.
- In the
left pane, navigate to
.
- In the
right pane, right-click
Named
Pipes, and ensure
Enable option is selected.
- In the
Client Protocols Properties window, right-click
Named Pipes and select the order, click
Move Up or
Move Down to change the order of the protocols as
follows: Shared Memory, Named Pipes, TCP/IP, then click
OK.
- In the
left pane, expand
SQL Server Network Configuration, and select
Protocols for MSSQLSERVER.
- In the
right pane, right-click
Named Pipes, and select
Enable, and click
OK.
- In the
right pane, right-click
TCP/IP, and select
Enable.
|
Step 17
| Enable
Autogrowth as follows:
- Open
SQL Server 2014 Management Studio.
- Click
Connect. In the left pane, expand
Databases > System Databases.
- Right-click
tempdb and select
Properties.
- In the
left pane, select
Files. Ensure that
AutoGrowth is enabled for both
tempdev and
templog.
- For
Maximum File Size, select
Unlimited option, applicable for both tempdev and
templog.
- For
File Growth, enter
10
In Percent field, applicable for both tempdev and
templog.
- Set
initial size (MB) as
1400 for tempdev and
1024 for templog and click
OK.
|
Step 18
| Set the SQL
Server's default language to
English as follows:
- On
SQL Server Management Studio page, right-click on the
server and choose
Properties.
- Click
Advanced.
- In
Miscellaneous section, choose
English from
Default Language drop-down list.
Important:
You must
set the SQL Server default language to English because Unified CCE requires a
US date format (MDY). Many European languages use the European date format
(DMY) instead. This mismatch causes queries such as
select * from table where date = '2012-04-08 00:00:00'
to return data for the wrong date.
|
Step 19
| Restart the
SQL Server service.
|