Can someone show me step by step how to do this with images? I do not think I am
ID: 3661374 • Letter: C
Question
Can someone show me step by step how to do this with images? I do not think I am doing it correctly.
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.
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.
Use SQLCMD to test connecting to the SQLSERVERCSU named instance using Shared Memory.
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.
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.
Explanation / Answer
SQLCMD also applies here. In addition, you can use “-Stcp:Your_target_machine, Tcp_port” for TCP, “-Snp:Your_target_machineYour_instance” for NP, and “-Slpc:Your_target_machineYour_instance” for Shared Memory. You would know if it fails for all protocols or just some specific procotols.
At this stage, you should not see general error message such as error 26 and error 40 anymore. If you are using NP and you still see error 40 (Named Pipes Provider: Could not open a connection to SQL Server), please try the following steps:
If you get failure in b), it’s very likely you have OS/Network configuration issue, which is not SQL Server specific. Please search on internet to resolve this issue first.
You can try connection using both Windows Authentication and SQL Authentication. If the tests with all tools failed, there is a good chance that steps 1-3 were not set correctly, unless the failure is logon-related then you can look at step 6.
If you succeeds with some of the tools, but fails with other tools, it’s probably a driver issue. You can post a question on our forum and give us the details.