Secure replication of Proxy server and SQL Server on databases

The steps for defining a protocol for SQL Server on Winsock are as follows: 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 running Proxy server. 3. Right-click the Winsock Proxy Service, and then click Properties. 4. In the Winsock Proxy Service Properties for ComputerName dialog box, click Protocols, and then click Add. 5. In the Kyoto Name text box, enter the name of the computer where the replication Distributor is located. 6. In the Port text box, enter 1433. 7. Under Type, select TCP, under Direction, select Inbound. Setting up a publishing Server/distributor and proxy Server working together after proxy server is installed on the proxy, the Publisher/distributor must be set up as a proxy server customer. This requires that SQL Server be bound to the Winsock port to communicate with the Internet. Bind to Winsock port for Internet communication to set up a publishing server/distributor and proxy server to work together, you must have files on the server running SQL Server (Publisher/distributor) \mssql7\binn\ Wspcfg.ini. If this file does not exist, create one with Notepad. This file should include the following: [Sqlservr]serverbindtcpports=1433persistent=1killoldsession=1sql server listens for connection requests on Proxy Server service port 1433. When a MSSQLSERVER account is granted unrestricted access, any user, service, or anonymous subscriber can request SQL Server authentication. You can set the protocol for port 1433 on proxy server to allow only the specified IP address to establish a connection. Set SQL Server to proxy client when proxy server is installed, share name MSPCLNT is created for folder C:\Msp\Clients. Run the Proxy client Setup program in this folder to set up SQL Server as a proxy client. After the installation is complete, SQL Server is the internal customer of proxy server. The steps for running the Proxy client setup program are as follows: 1. On the server running SQL Server, click Start, and then click Run 2. Under Open, enter \\SERVERNAME\MSPCLNT, and then run the Proxy Server client Setup program 3. Reboot the computer after installation to make the settings take effect the editor Zhao Zhaoyi#51cto.com TEL: (010) 68476636-8001 to force (0 votes) of the (0 Votes) nonsense (0 Votes) Professional (0 Votes) The title party (0 Votes) passed (0 Votes) Original: Proxy Server and SQL Server secure replication on database back to network security home