IP not listening for one SQL instance in an active active cluster.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » IP not listening for one SQL instance in an...

IP not listening for one SQL instance in an active active cluster.

Rate Topic

Display Mode

Topic Options

Author

Message

joe.wiitala

Posted Friday, May 30, 2008 11:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 05, 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

ALZDBA

Posted Friday, May 30, 2008 11:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

did you enable it to use tcp/ip ?

Johan

     Jul 13

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

- 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" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #509285

joe.wiitala

Posted Friday, May 30, 2008 12:10 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 05, 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

Jeffrey Williams 3188

Posted Friday, May 30, 2008 2:07 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 11:21 AM
Points: 4,317, Visits: 9,216

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 »

Permissions