Sql Server Laboratorio Microsoft | Microsoft Sql Server | Port ...

Lab Answer Answer Key: Module Module 1: Introduction Introduction to SQL Server 2012 and Its ...

Lab Answer 2012 and Lab 1: Introduction

https://skillpipe.course https://skillpipe.courseware-mark ware-marketplace.com etplace.com/reader/es/reader/es-ES/Book/Bo ES/Book/Book... ok...

Server 

Toolset

Lab Setup For this lab,

begin the lab,

you must complete

•

Revert the

txt.

Exercise

Task 1: Check installed for

1.

Click Start Configuration

1.

been

In the left-hand

. click SQL

Server

2.

In the right-hand instance: •

SQL

•

SQL

•

SQL

•

SQL

MKTG

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

Task 2: Note

1.

In the left-hand

click SQL

Server

2.

In the right-hand

default

instance: •

SQL

•

SQL

•

SQL

•

SQL

Task 3: Ensure started and

1.

Check

are

Automatic.

Ignore 2.

Check

Automatic.

Ignore

Exercise

Task 1: Change

1.

In the left-hand

click SQL

Server

d

2.

In the right-hand

3.

In the Account

Properties.

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

4.

In the Password

5.

In the Confirm

6.

In the Confirm

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

Task 2: Change

1.

In the left-hand

click SQL

Server

2.

In the right-hand

3.

In the Account •

Properties.

AdventureWorks\PWService

4.

In the Password

5.

In the Confirm

6.

Right-click

Exercise

service.

Instances

Task 1: Enable

1.

In the left-hand Server

2.

In the right-hand

expand SQL MSSQLSERVER.

right-click Named

Pipes and

Task 2: Enable

d

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

1.

In the left-hand

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

click Protocols

for MKTG

2.

In the right-hand

right-click Named

Pipes and

Task 3: Restart

1.

In the left-hand

click SQL

Server

2.

Right-click

3.

Right-click

4.

In the left-hand

click SQL

Server

5.

In the toolbar,

Exercise

Task 1: Create

1.

In the left-hand

expand SQL

Native

d

2.

Confirm

3.

In the left-hand

4.

In the left-hand

5.

In the Alias

6.

In the Protocol

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

7.

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

In the Server

Task 2: Create

1.

In the left-hand

expand SQL

Native

2.

Confirm

3.

In the left-hand

4.

In the left-hand

5.

In the Alias

6.

In the Protocol

7.

In the Server

Task 3: Use work s as expected

1.

Click Start

to ensur e it

then click 

SQL Server

2.

In the Connect

3.

In the Server

4.

In the Authentication

Database Engine.

and click 

Connect

5.

In Object

Note: Databases, ReportServer$MKTGTempDB.

d

System

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

Challenge TCP/IP Port ( Task 1: Configure 51550

1.

In the Virtual Microsoft

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

Configu re a Fixed

instance to

click  SQL Server

Configuration

2.

In the left-hand

expand SQL

Server

3.

Right-click

4.

In the TCP/IP

5.

Scroll to

for TCP

Dynamic

6.

For TCP

7.

In the Warning

8.

In the left-hand

9.

Right-click

10.

In the left-hand

click SQL

Server

11.

In the toolbar,

Task 2: Disable

1.

In the left-hand

click SQL

Server

2.

d

In the right-hand

, right-click 

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

SQL Server

3.

Right-click

4.

In the SQL

Start Mode to

Disabled

5.

d

Close SQL

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

d

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

d

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

/

/

Lab Answer Key: Module 1: Introduction to SQL Server 2012 and Its ...

d

https://skillpipe.courseware-marketplace.com/reader/es-ES/Book/Book...

/

/