Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

After changing port on a cluster the proper way, default connection without port specified still working Expand / Collapse
Author
Message
Posted Sunday, July 28, 2013 3:21 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:55 PM
Points: 644, Visits: 2,139
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 as well.

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.


Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
Post #1478338
Posted Sunday, July 28, 2013 3:26 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:55 PM
Points: 644, Visits: 2,139
Attached are three lines that might be important from the Errorlog. Not sure if the \pipe connections matter.

Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein


  Post Attachments 
port.JPG (15 views, 24.38 KB)
Post #1478339
Posted Monday, July 29, 2013 6:43 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:55 PM
Points: 644, Visits: 2,139
Anyone? :-(

Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
Post #1478557
Posted Friday, August 2, 2013 2:11 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:16 AM
Points: 85, Visits: 377
SQL Browser service turned on possibly?
Post #1480598
Posted Tuesday, August 6, 2013 2:39 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:55 PM
Points: 644, Visits: 2,139
DeadScorpius (8/2/2013)
SQL Browser service turned on possibly?

No, it's off...it seems that 1433 indeed was not listening. However, we had to let the network admins open up our new port. If you don't, SQL was resolving through port 445, SMB. It connected, but was slow. Once he opened up the new port, everything went well.


Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
Post #1481563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse