Question: 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

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. 1.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. 2.Use SQLCMD to test connecting to the SQLSERVERHOA named instance using Shared Memory. 3.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. 4.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,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!