PHP网页编程之如何才干限制SQL Server只能让指定的机...

模仿的不光是模仿，模仿的同时在加改进，就成了自己的作品了。server   Q. How can I restrict access to my SQL Server so that it only allows certain machines to connect?
(v1.0 19.10.1998)


如何才干限制我的SQL Server只能让指定的机械毗连


A. SQL Server has no built-in tools/facilities to do this. It also does not have the facility to run a stored-procedure on connection that could be written/used to do this. Therefore you have the following choices :-

   SQL Server没有如许的功效，也没有供应在毗连时履行某一特定进程的功效。这里引见几种完成的办法

1. Put the SQL Server behind a firewall and use that to restrict access. This is the most secure and functional way to do what you want.

    利用防火墙，它供应了平安和你想用的东西。

2. Write your own ODS Gateway and point the clients at that instead of the SQL Server - the ODS Gateway will then do the checking. However, there is nothing stopping clients figuring out the correct SQL client-config entries to point straight at the SQL Server. There are examples of ODS code in the SQL Programmers Toolkit - available for free download from the MS website.

    写本人的ODS网关取代SQL Server的客户端 - 在ODS网关中反省。不外，这其实不能中断正常的客户端毗连SQL Server。在SQL Programmers Toolkit中有一个如许的例， 可以从微软站点收费下载。

3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), and then issues a KILL command for any processes that should not be running. Note that this only works for MAC addresses. This way allows people to connect and possibly make changes before they are spotted and killed.

    写一个存储进程反省sysprocesses中的响应列（net_address）

　
  让好朋友来看看，嘿，看咱写的多棒，然后再在网上宣传一下。

php里的数组为空的时候是不能拿来遍历的；（这个有点低级啊，不过我刚被这个边界问题墨迹了好长一会）