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

IP not listening for one SQL instance in an active active cluster. Expand / Collapse
Author
Message
Posted Friday, May 30, 2008 11:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 5, 2009 11:40 AM
Points: 2, Visits: 4
Here's the error log. I don't see the virtual IP instance listening, only the local IP.

I do see the IP in the TCP/IP properties in the protocol for the instance in configuration manager.

2008-05-30 12:54:35.57 Server A self-generated certificate was successfully loaded for encryption.
2008-05-30 12:54:35.57 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\PROJECT07 ].
2008-05-30 12:54:35.57 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$PROJECT07\sql\query ].
2008-05-30 12:54:35.60 Server Server is listening on [ 127.0.0.1 2091].
Post #509278
Posted Friday, May 30, 2008 11:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,731, Visits: 8,483
did you enable it to use tcp/ip ?

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #509285
Posted Friday, May 30, 2008 12:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 5, 2009 11:40 AM
Points: 2, Visits: 4
Yes TCP/IP is enabled. It seems to only bind a port number to the local address not the virtual IP.
Post #509296
Posted Friday, May 30, 2008 2:07 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:09 PM
Points: 4,358, Visits: 9,538
Is SQL Browser running?

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #509360
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse