In our Availability group I have a reporting server where report writers will connect directly and also crystal reports will be used, If the listener port is 1433 and the clients also gets connected through port 1433 to the reporting server that is part of the Availability group will there be any port conflict.
SQL Server 2014 Listener Port 1433 for Always On Availability Group
availability-groupshadrhigh-availabilitylistenersql server 2014
Related Question
- Sql-server – Read only replica part of always on availability group for Reporting
- Sql-server – What happens when the same application from different server tries to connect to the always on primary server
- SQL Server – Stored Procedure on Read-Only AlwaysOn Availability Group Replica
- Find DNS Name Associated with Listener of SQL Server Availability Group
- SQL Server – Fixing Connection Issues to Always On Availability Listener
- Sql-server – Web server accessing the database server in Always on availability group
Best Answer
If 1433 is just dedicated to sql server and no other service is using it, there wont be any conflicts.
This is documented well in BOL :