August 27, 2014 at 12:26 pm
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.
August 27, 2014 at 1:17 pm
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.
😎
September 4, 2014 at 6:35 am
Sorry for the slow response. We have a physical connection to them. No VPN or Internet and no trusted domain. That said we are going to create some static ports, just not 1433.
My only question now, as previously stated we do not have a test cluster environment. So I'll test the configuration process on a server. When we installed two new named instances on our cluster, we created two new IPs. Everything I've read suggests it is not necessary to create an IP for new named instance on a server which already hosts a SQL Server default instance?
Why was it necessary to do this on the cluster? I've been Googling the subject, any relevant URLs would be appreciated - thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply