How can I restrict SQL Server to only allow the specified machine to connect (GO) _php tutorial

Source: Internet
Author: User
Tags sql client
Q. How can I restrict access to my SQL Server so is it only allows certain machines to connect?
(v1.0 19.10.1998)
How can I restrict my SQL Server to only the specified machine connection
A. SQL Server has no built-in tools/facilities to does this. It also does not having the facility to run a stored-procedure on connection that could is written/used to doing this. Therefore you have the following choices:-
SQL Server does not have such functionality and does not provide the ability to perform a particular procedure when connected. Here are a few ways to implement
1. Put the SQL Server behind a firewall and use this to restrict access. The most secure and functional-to-do want.
Using a firewall, it provides the security and tools you want to use.
2. Write your own ODS gateway and point the clients on that instead of the SQL server-the ODS Gateway would then do the C Hecking. However, there is nothing stopping clients figuring out the correct SQL client-config entries to point straight at the SQL Server. There is examples of ODS code in the SQL programmers toolkit-available for free download from the MS website.
Write your own ODS gateways instead of SQL Server clients-check in the ODS gateway. However, this does not stop the normal client connection to SQL Server. There is one such example in SQL Programmers Toolkit that can be downloaded for free from the Microsoft site.
3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), an D then issues a KILL command for any processes this should not be running. Note that this is only works for MAC addresses. This is allows people to connect and possibly make changes before they is spotted and killed.
Write a stored procedure to check the corresponding column (net_address) in sysprocesses
 

http://www.bkjia.com/PHPjc/631105.html www.bkjia.com true http://www.bkjia.com/PHPjc/631105.html techarticle Q. How can I restrict access to my SQL Server so is it only allows certain machines to connect? (v1.0 19.10.1998) How can I restrict my SQL Server to only the specified machine connections ...

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