File and printer sharing for Microsoft networks is an example of a network protocol

What's the difference between "file sharing" (first image) and "File and Printer Sharing for Microsoft Networks" (second image) ?

File and printer sharing for Microsoft networks is an example of a network protocol

File and printer sharing for Microsoft networks is an example of a network protocol

Initially I thought they were the same thing - just a different UI - so turning one off would turn the other off and turning one on would turn the other on.

However after experimenting, I found that they are in fact independent of each other. What's the difference between them?

File and printer sharing for Microsoft networks is an example of a network protocol

Gaff

18.3k14 gold badges56 silver badges68 bronze badges

asked Oct 14, 2011 at 8:30

The "File and Printer Sharing for Microsoft Networks" component is the software that provides the file sharing functionality. However, just because the software is installed doesn't mean that sharing is enabled.

The first dialog box says "To turn off file sharing, Windows Firewall will be enabled" so I conclude that the function of that dialog is to configure the Windows Firewall to either allow or disallow file sharing.

Functionally, this means that file sharing has to be on in both places in order to work.

answered Oct 17, 2011 at 0:00

Harry JohnstonHarry Johnston

5,6447 gold badges30 silver badges55 bronze badges

5

Introduction to Computer NetworksChapter 1TRUE/FALSE1.File and printer sharing for Microsoft networks is an example of a network protocol.PTS:1REF:Page 16

Get answer to your question and much more

2.A network that has locations in different countries is considered a WAN.PTS:1REF:Page 28

Get answer to your question and much more

3.In order to find out your MAC address, you should open a command prompt and type ipconfig /all.PTS:1REF:Page 23

Get answer to your question and much more

4.What makes a computer a “server” is the fact that it has a server operating system installed on it.PTS:1REF:Page 33

Get answer to your question and much more

5.Each component of a computer is designed to perform only one specific task—either input, processing,or output.PTS:1REF:Page 2

Get answer to your question and much more

MULTIPLE CHOICE1.The XYZ company has two offices, one downtown, and a brand new office in the newer section oftown. To connect the two offices, they will need a dedicated line, probably leased from the local phonecompany. What type of network will they be implementing to connect their two offices?PTS:1REF:Page 28

Get answer to your question and much more

2.Airwaves are an example of what type of network component?PTS:1REF:Page 15

Get answer to your question and much more

3.Windows 7, Windows Vista, and Windows XP are all examples of which of the following?

Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Network Protocols and Network Libraries

  • Article
  • 03/11/2022
  • 2 minutes to read

In this article

Applies to: SQL Server (all supported versions) - Windows only

A server can listen on, or monitor, multiple network protocols at one time. However, each protocol must be configured. If a particular protocol is not configured, the server cannot listen on that protocol. After installation, you can change the protocol configurations using the SQL Server Configuration Manager.

Default SQL Server Network Configuration

A default instance of SQL Server is configured for TCP/IP port 1433, and named pipe \\.\pipe\sql\query. SQL Server named instances are configured for TCP dynamic ports, with a port number assigned by the operating system.

If you cannot use dynamic port addresses (for example, when SQL Server connections must pass through a firewall server configured to pass through specific port addresses). Select an unassigned port number. Port number assignments are managed by the Internet Assigned Numbers Authority and are listed at https://www.iana.org.

To enhance security, network connectivity is not fully enabled when SQL Server is installed. To enable, disable, and configure network protocols after Setup is complete, use the SQL Server Network Configuration area of the SQL Server Configuration Manager.

Server Message Block Protocol

Servers in the perimeter network should have all unnecessary protocols disabled, including server message block (SMB). Web servers and Domain Name System (DNS) servers do not require SMB. This protocol should be disabled to counter the threat of user enumeration.

Warning

Disabling Server Message Block will block the SQL Server or Windows Cluster service from accessing the remote file share. Do not disable SMB if you do or plan to do one of the following:

  • Use Windows Cluster Node and File Share Majority Quorum mode
  • Specify an SMB file share as the data directory during SQL Server installation
  • Create a database file on an SMB file share

To disable SMB

  1. On the Start menu, point to Settings, and then click Network and Dial-up Connections.

    Right-click the Internet-facing connection, and then click Properties.

  2. Select the Client for Microsoft Networks check box, and then click Uninstall.

  3. Follow the uninstall steps.

  4. Select File and Printer Sharing for Microsoft Networks, and then click Uninstall.

  5. Follow the uninstall steps.

To disable SMB on servers accessible from the Internet

  • In the Local Area Connection properties, use the Transmission Control Protocol/Internet Protocol (TCP/IP) properties dialog box to remove File and Printer Sharing for Microsoft Networks and Client for Microsoft Networks.

Endpoints

SQL Server introduces a new concept for SQL Server connections; the connection is represented on the server end by a Transact-SQLendpoint. Permissions can be granted, revoked, and denied for Transact-SQL endpoints. By default, all users have permissions to access an endpoint unless the permissions are denied or revoked by a member of the sysadmin group or by the endpoint owner. The GRANT, REVOKE, and DENY ENDPOINT syntax uses an endpoint ID that the administrator must get from the endpoint's catalog view.

SQL Server Setup creates Transact-SQL endpoints for all supported network protocols, as well as for the dedicated administrator connection.

Transact-SQL endpoints created by SQL Server Setup are as follows:

  • Transact-SQL local machine

  • Transact-SQL named pipes

  • Transact-SQL default TCP

For more information about endpoints, see Configure the Database Engine to Listen on Multiple TCP Ports and Endpoints Catalog Views (Transact-SQL).

For more information about SQL Server network configurations, see the following articles in SQL Server Books Online:

  • Server Network Configuration

See Also

Surface Area Configuration
Security Considerations for a SQL Server Installation
Planning a SQL Server Installation

Feedback

Submit and view feedback for

What is file and printer sharing for Microsoft Networks?

File and printer sharing in Microsoft® Windows® allows you to share the contents of selected folders and locally attached printers with other computers.

Which protocol is used by the client for Microsoft Networks and file and printer sharing?

The Server Message Block (SMB) Protocol is a network file sharing protocol, and as implemented in Microsoft Windows is known as Microsoft SMB Protocol.

What is a network protocol quizlet?

Networking protocols define a common format and set of rules for exchanging messages between devices. Some common networking protocols are Hypertext Transfer Protocol (HTTP), Transmission Control Protocol (TCP), and Internet Protocol (IP).

Which of the following is the default protocol Windows uses to share folders?

A Microsoft Windows file share is a specific folder in your file system. It includes that folder's subfolders, which you make accessible to your compute instances with the Server Message Block (SMB) protocol. Your file system comes with a default Windows file share, named share .