Secure replication of Proxy server and SQL Server on databases

Source: Internet
Author: User
Keywords Security
Tags click client console distributor information information service internet internet +
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.