Set up proxy server and SQL Server to implement database security on the Internet

First, we need to look at the steps SQL Server defines on Winsock:

1. On the Start menu, point to Program/microsoft Proxy Server, and then tap Microsoft Management Console.

2. Expand Internet Information Service, and then expand the server that is running Proxy server.

3. Right-click the Winsock Proxy service and click Properties.

4. In the Winsock Proxy Service Properties for ComputerName dialog box, click Protocols, and then click Add.

5. In the Protocol Name text box, enter the name of the computer where the replication Distributor resides.

6. In the Port text box, enter 1433.

7. Under Type, select TCP, under Direction, select Inbound.

Then set up the publishing Server/distributor and proxy server to work together, after the proxy server is installed, we must set up the publishing Server/distributor as a proxy server client. This requires that SQL Server be bound to a Winsock port for communication with the Internet.

To bind to a Winsock port to communicate with the Internet, to set up a publishing server/distributor and proxy server, you must be on the server that is running SQL Server (publishing server/ The file Mssql7binnwspcfg.ini exists on the Distributor. If this file does not exist, we will have to use Notepad to create a. This file should contain the following content:

[sqlservr]
serverbindtcpports=1433
Persistent=1
Killoldsession=1

SQL Server listens for connection requests on the Proxy Server service port 1433. When you grant unrestricted access to a SQL Server account, any user, service, or anonymous subscriber can request SQL Server authentication. The protocol for port 1433 can be set on the proxy server, allowing only the specified IP address to establish a connection.

Set SQL Server as a proxy client

After we have installed Proxy server, we have created the share name mspclnt for the folder c:mspclients. Run the Proxy client Setup program in this folder to set SQL Server as a proxy client. After the installation is complete, SQL Server is the internal client of proxy server.

To run the Proxy client Setup program, proceed as follows:

1. On the server that is running SQL Server, click Start, and then click Run.

2. Under Open, enter/SERVERNAMEMSPCLNT, and then run the Proxy Server client setup program.

3. Restart the computer after the installation is complete to make the settings effective.

Http://www.atcto.net/Tech/SQL/2012-10-24/SQL,12102408424500000010.html