Describe how TCP/IP is used in SQL Server 2012 remote connectivity.

What will be an ideal response?

TCP/IP is the most common protocol used for remote connectivity. The default instance of SQL Server is configured to listen on TCP port 1433; other TCP ports are assigned for a named instance dynamically when the database engine service starts.

Computer Science & Information Technology

You might also like to view...

The slides in a kiosk presentation will NOT advance on a mouse click

Indicate whether the statement is true or false

Computer Science & Information Technology

To save a chart as a template, select the chart, click the ________ tab, and then click Save as Template in the Type group

Fill in the blank(s) with correct word

Computer Science & Information Technology