For this hands-on project, you will use the SQL Server named instance SQLSERVERH

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 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.

Explanation / Answer

Solution:

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.