Configure remote clients to access the SQL server using the named pipe Protocol

Configure remote clients to access the SQL server using the named pipe Protocol

Original Works are allowed to be reproduced. During reprinting, be sure to mark them as hyperlinks.ArticleOriginal source, author information, and this statement. Otherwise, legal liability will be held. Http://alligator.blog.51cto.com/36993/79687

There are two common sqlserver2000 communication protocols:
1: TCP/IP
2: Named Pipe
This is the default communication protocol of sqlserver2000. It uses/server name/pipe/SQL/query to identify the server.

The named pipe protocol accesses the named pipe through sharing. This requires that before access, the remote client must access the named pipe through an account/password that can access the shared resources of the server.

The simplest method is to use the net use command in the command line to establish a remote connection to the server.
For example: net use // myserver/IPC $ password/User: Administrator

Note: The password is the password of the administrator of the myserver computer account!
Administrator must be an account on the server with the permission to enable the named pipe server.

This article is from "My son is really handsome !" Blog, please be sure to keep this source http://alligator.blog.51cto.com/36993/79687