jralston88 (8/27/2014)
We have a SQL Server 2008 Enterprise cluster two node environment (64 bit). We have a default instance and two named instances on it. With named instances we have dynamic ports. One of our customers requested that we reduce the dynamic port number for one named instance to less than five thousand (not comfortable doing this as we only have a production environment).One question came to mind. With the named instances, should we attempt to change the dynamic port to a static port 1433? On the surface it seems it would not want to go that route. That said reviewing one article on "How to Change the Dyanmic Port of the SQL Server Named Instance to the Static Port in a SQL Server 2005 Clustered Instance" seemed to support that idea (pretty decent article).
Any ideas, comments and most important URLs (for cluster environment) would be appreciated. Thanks.
Quick question, how are the customers connecting? Via VPN/MPLS/SSH Tunnel or open Internet via your gateway?
Is it a trusted domain??? Hard to make any suggestions as the impact of those isn't clear. My first thought is a non-standard static port but that also depends on quite few factors.
😎