Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Lab Answer SQL Server

Configuring

Lab: Installing Exercise

Task 1: Prepare

1.

Ensure are running,

virtual machines ADVENTUREWORKS\Student

with the 2.

In the D:

click Run as

administrator 3.

Click Yes

file, and then

wait for

Task 2: View

1.

In the C:

Access Control

message 2.

In the SQL

Hardware and

Software 3.

In Internet hardware

information about Internet Explorer.

Task 3: Run

1.

1 of 9

In the SQL

Configuration

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Checker 2.

When the

3.

Click OK

4.

Keep the

performed.

again in a later

exercise.

Result: After the tools in Server installation.

and used readiness for SQL

Exercise

Task 1: Review

1.

Review

2.

Verify that

not, create

them).

Task 2: Install

1.

In the SQL Server

New SQL installation wait for

SQL Server 2.

If the Microsoft

any

checkboxes 3.

4.

2 of 9

On the

that has been

checked.

it.

On the

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

5.

On the

SQL Server

2014 is 6.

On the

7.

On the

and check I

accept 8.

On the

selected, and

then click 9.

On the

Database Engine

Services 10. On the

selected, type

SQLTEST 11.

On the

Server

Database

o

Account

o

Password

o

Startup

12. On the

selected and

click Next 13. On the Authentication Windows 14. Click Add

Configuration tab, in the authentication and . Student

(Student 15. On the

\SQLTEST

\Data.

3 of 9

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

16. Change 17. On the

Transact-SQL

access 18. On the

and wait for

the installation 19. On the 20. Close the

Result: After

Exercise

Task 1: Start

1.

On the

the User

Account 2.

In the left-hand

click SQL

Server 3.

In the right-hand

4.

In the SQL configured

service is Start. Then,

when the

Task 2: Configure

1.

In SQL

Configuration,

click Protocols

enabled for this

instance

4 of 9

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

2.

In SQL

Configuration

(32bit)

enabled for 32-bit

client applications. 3.

Click Aliases

clients. Then

right-click 4.

In the Alias

5.

In the Protocol

6.

In the Server

7.

In SQL click Client

Configuration, 64-bit client

applications. 8.

Click Aliases

clients. Then

right-click 9.

In the Alias

10. In the Protocol 11.

In the Server

12. Close SQL

Task 3: Verify

1.

Right-click

2.

At the command MIA-SQL\SQLTEST sqlcmd

3.

5 of 9

At the sqlcmd

Server instance

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

name: SELECT GO

4.

Close the

5.

Start SQL

database

engine 6.

In Object

the value of

the Name 7.

In Object message

Control stop the

MSSQL$SQLTEST 8.

When the

Result: After using SSMS.

6 of 9

connected

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

7 of 9

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

8 of 9

26/09/2016 15:59

Lab Answer Key: Module 2: Installing and Configuring SQL Server 2014 https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

9 of 9

26/09/2016 15:59