\"For this Critical Thinking Assignment, you will complete the hands-on activity
ID: 3582423 • Letter: #
Question
"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 School's Guide to Writing and APA."
--
I have successfully used shared memory to test the connection. I can not connect through TCP/IP, despite enabling TCP/IP for the server in configuration manager, applying 127.0.0.1 for IPv4 address, 4459 for port, restarting the server, and even switching the native client configuration ports from their defaults to 4459.
--
From Command Prompt:
C:UsersUser>SQLCMD -S LOCALHOSTSQLSERVERHOA -Q "Select GETDATE();"
-----------------------
2016-12-17 11:13:07.120
(1 rows affected)
C:UsersUser>SQLCMD -S LPC:LOCALHOSTSQLSERVERHOA -Q "Select GETDATE();"
-----------------------
2016-12-17 11:13:11.180
(1 rows affected)
C:UsersUser>SQLCMD -S 127.0.0.1SQLSERVERHOA -Q "Select GETDATE();"
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. .
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login timeout expired.
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
C:UsersUser>sqlcmd -s tcp:127.0.0.1sqlserverhoa,4459 -Q "Select Getdate();"
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Named Pipes Provider: Could not open a connection to SQL Server [2]. .
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login timeout expired.
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Explanation / Answer
Here the instance is named as SQLSERVERHOA. Connection to a named instance on the same computer using a "period" to indicate that the instance is running on the local computer.
".SQLSERVERHOA" instead of "127.0.0.1SQLSERVERHOA" will solve your problem.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.