Monday, July 26, 2021

Usually, we do not need to specify TCP port when connecting to SQL Server since SQL Server Browser service will do that. If this application really requires to be assigned a TCP port while connecting to its database, I think the set SQL Server to listen on a static port may be a good choose. If you use dynamic port, you may need to update the TCP port each time of SQL Server restarting for this application.

No comments:

Post a Comment