Posted: December 21st, 2015

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

For this hands-on project, you will use the SQL Server named instance SQLSERVERCSU that 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 1433.
2.Use SQLCMD to test connecting to the SQLSERVERCSU named instance using Shared Memory.
3.Use SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433. 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 one page report, which follows the CSU-Global Guide to Writing and APA Requirements.

After you have completed this Critical Thinking Assignment, submit one MS Word document that contains three screenshots and the written report. Your first screenshot should document your configuration of the TCP/IP server listener to use the static TCP port 1433; the second screenshot should document the connection test using shared memory; and the third screenshot should document your use of the SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433, 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’re welcome to do so. Insert all of the screenshots into one MS Word document, label each of them clearly, and include the one page report below the screenshots; then upload this single MS Word document to the assignment page.