2

I have a push subscriber in transactional replication (and the distributor is the publisher), in this subscriber I configured sql server port on 1433, and I have a web application which connect to this subscriber database, and I want to use any port but not 1433, Can I configure SQL server to listen to two different ports one will be used in replication from distributor IP (which stay 1433) , and the other for web request (from web server IP), and how to do that ??

In case of a single port, If the default port of sql server(1433) is changed this will affect on replication cause subscriber and publisher listening on the same port, is this right ??

1 Answer 1

4

Yes, SQL Server can be configured to listen on multiple IPs and multiple ports. Read Configure the Database Engine to Listen on Multiple TCP Ports.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.