I have a strange issue on a SQL 2008 cluster (non-R2) that I changed the default port on. I went ahead and followed the instructions in this link
and this one
The change was from 1433 to 1599 and after following the instructions about removing checkpoints, changing IP on both nodes, and adding back the checkpoints, I verified via the log file the message: Server is listening to [XXX.XXX.XXX.XXX <ipv4> 1599]
I also took the liberty of disabling SQL Browser on both nodes.
The strangeness occurs when connecting from Management Studio. When connecting to the SQL Name without a port after, it resolves the port. I thought somehow that 1433 was still active, but when I connected to ServerName,1433
via Management Studio, the connection failed as it should. When I connected to ServerName,1599
, the new port, it worked. But connecting just to ServerName
resolved the connection, although I did notice there was a slight delay, almost as if something on the back end was taking an extra step to resolve.
Is there any way to permanently disable the default behavior, meaning I would require all connections, even those from Management Studio, to specify the correct port? Thanks very much.
________________________________________________________________"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein