Database Management: WINTER17-C-8-ITS410-2

Prev

External Tool Module 2: Discussion For ...

Next

External Tool Module 2: Critical Think ...

Folder.Module 2: SQL Server Organization and Configuration

Module 2: Critical Thinking

CRITICAL THINKING ASSIGNMENT (60 points)

For this Critical Thinking Assignment, you will complete the hands-on activity, Project 3-1: Client/Server Connectivity, based on p. 112 of the MCSA guide to Microsoft SQL server 2012 textbook.

For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA you created for the Module 1 Critical Thinking Assignment. The objective of this assignment is to configure and test client/server connectivity using a variety of network protocols that are supported by SQL Server 2012. Document your work by taking a screen shot at the end of each step.

Begin by ensuring that the Shared Memory and TCP/IP protocols are enabled for your instance using the SQL Server Configuration Manager. Configure the TCP/IP server listener to use the static TCP port 4459.

Use SQLCMD to test connecting to the SQLSERVERHOA named instance using Shared Memory.

Use SQLCMD to test connecting to the SQLSERVERHOA TCP/IP listener on TCP port 4459. Use the 127.0.0.1 loopback address to simulate the network.

Troubleshoot any failures in Steps 2 and 3. For each failure, document the steps that were taken to diagnose and resolve each issue. Then reflect on this process and any difficulty that you experienced when carrying out these tasks in a report of at least 1-page, following the CSU-Global Guide to Writing and APA.

Deliverable

After you have completed these steps, submit one MS Word document that contains your screenshots and the written report. Your first screenshot should document your configuration of the TCP/IP server listener to use the static TCP port 4459. The second screenshot should document the connection test using shared memory. The third screenshot should document your use of the SQLCMD to test connecting to the SQLSERVERHOA TCP/IP listener on TCP port 4459, while using the 127.0.0.1 loopback address to simulate the network. The minimum number of screenshots that should be included is three; however, if you feel like you need to include more than that, you are welcome to do so. Insert all of the screenshots into one MS Word document, label each of them clearly, and include the 1-page minimum report below the screenshots.