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