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