Accessing SQL Server using Named pipes

Source: Internet
Author: User
Tags microsoft sql server connect resource client
One, meaning
After SQL Server installation, the default configuration is to allow clients to access the TCP/IP protocol, and users need only know the password of the SQL Server account to access it, which is
Not safe, because many web programs are directly to the connection information (database server, Connection account, connection password) written in the program, the attacker or hacker can through some
method to directly view the source code to obtain the SQL Server account and password, they can directly use the TCP/IP protocol to connect to the database server, the data or configuration to modify the
To be destroyed. When using Named pipes, users must have access to the resources of the machine where SQL Server resides before they can access SQL Server if the user does not have access to the
The source's permissions, even if he knows that SQL Server account is not connected.

Second, realize
1, server Configuration
Open SQL Server's server network Utility: "Start-> program->microsoft SQL Server 7.0->server Network
Utility ", in the" General "column, remove the unnecessary connection configuration and press" Add ... "to add a Named Pipes connection: Network Librarys
Named pipes,server name is the server's machine name
2. Client Configuration
Open SQL Server's Client network Utility: "Start-> program->microsoft SQL Server 7.0->client Network
Utility ", in the" General "column, remove the unnecessary connection configuration and press" Add ... "to add a Named Pipes connection: Network Librarys
Named Pipes,server alias is the machine name (local area network) or IP address (wide area Network) of the server on which SQL Server is to be connected
3. Connection method
Can be divided into two categories:
A, the client has logged on to the domain where the server is located
The client already has access to the server resource and can connect directly to SQL Server
B, the client does not log on to the domain where the server resides
The client does not have access to the server resource, you can enter the \\< server machine name or IP address in "Start-> Run", and then enter the NT account and
Password to verify that the client has access to the server resource after passing, and that the client can then connect to SQL Server


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.