Set Proxy Server and SQL Server for database security

First, we need to understand the steps for SQL Server to define the protocol on WinSock:

1. on the "Start" menu, point to "Program/Microsoft Proxy Server", and then click "Microsoft Management Console ".

2. Expand Internet Information Service, and then expand the Server that runs the Proxy Server.

3. Right-click WinSock Proxy service and click Properties.

4. In the WinSock Proxy Service Properties For computername dialog box, click Protocols and then Add.

5. In the Protocol name text box, enter the name of the computer where the replication distributor is located.

6. Input 1433 in the Port text box.

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

Then set the Publishing Server/distributor to work with the Proxy Server. After the Proxy Server is installed on the Proxy Server, we must set the Publishing Server/distributor to the Proxy Server customer. This requires that the SQL Server be bound to the WinSock port for communication with the Internet.

To bind to the WinSock port for communication with the Internet, you must set the Publisher/distributor to work with the Proxy Server on the Server running SQL Server (publisher/distributor) the Mssql7BinnWspcfg file exists. ini. If this file does not exist, we must use Notepad to create one. This file should include the following content:

[Sqlservr]
ServerBindTcpPorts = 1433
Persistent = 1
KillOldSession = 1

SQL Server listens for connection requests on Proxy Server Service port 1433. When an SQL Server account is granted unlimited access, any user, service, or anonymous subscriber can request SQL Server verification. You can set the port 1433 protocol on the Proxy Server to allow only the specified IP address to establish a connection.

Set SQL Server as a Proxy client

After we have installed the Proxy Server, we have created the shared name mspclnt for the C: MspClients folder. Run the Proxy client setup program in this folder and set SQL Server to the Proxy client. After the installation is complete, SQL Server is the internal customer of Proxy Server.

To run the Proxy client setup program, follow these steps:

1. on the Server where SQL Server is running, click Start and then run.

2. Open/servernamemspclnt and run the Proxy Server Client Setup Program.

3. restart the computer after installation to make the settings take effect.