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 12»»

cluster network IP Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 7:19 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
Doing first 2012 active/passive cluster install. On the screen which looks the same as 2008 where it needs to validate the cluster network I put in the IP I was give to link to the sql instance name. It fails and tells me it can not validate the ip address. I can't even ping the IP from a command prompt. Am I missing something, I don't think this will work and validate if I can't ping it.




Post #1451104
Posted Thursday, May 9, 2013 7:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:32 AM
Points: 809, Visits: 1,157
Try to figure it out why you even can't ping that IP from command prompt.
If you can not ping it, SQL cannot validate it.
Post #1451118
Posted Thursday, May 9, 2013 7:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 373, Visits: 1,234
timscronin (5/9/2013)
Doing first 2012 active/passive cluster install. On the screen which looks the same as 2008 where it needs to validate the cluster network I put in the IP I was give to link to the sql instance name. It fails and tells me it can not validate the ip address. I can't even ping the IP from a command prompt. Am I missing something, I don't think this will work and validate if I can't ping it.



For a 2 node single instance cluster,this is what you need

One IP for the actual Windows Cluster
One IP for the SQL server instance
One IP for the MSDTC virtual ip
One IP for the Public NIC (each node)
One IP for the heartbeat network

Are you meeting those requirements? ... also, your public NIC and SQL server instance virtual IP, should be on same subnet.

Also, you do not mention which Os you are using. But if you are using Windows 2008R2 or similar, please ensure it is fully patched (both nodes). And that you can ping via IP and name to other node. I also like to ping (name and IP) the Domain Controller as well; MS Cluster uses AD a lot, so you need to ensure both nodes can ping the DC too.
Post #1451119
Posted Thursday, May 9, 2013 7:58 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
thanks you are validating what I thought, my network guy thinks the install will create the IP, I always thought the IP had to be setup and valid first. If I can't ping it no way for sql to validate it


Post #1451122
Posted Thursday, May 9, 2013 8:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
timscronin (5/9/2013)
thanks you are validating what I thought, my network guy thinks the install will create the IP, I always thought the IP had to be setup and valid first. If I can't ping it no way for sql to validate it

The install will create a clustered resource for the IP address you supply and link it to the Virtual network name. The IP address must be a free address that is not already in use.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1451148
Posted Thursday, May 9, 2013 8:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
right but if the ip is invalid (can't ping it) the resource will never be created,


Post #1451160
Posted Thursday, May 9, 2013 9:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
Are you saying you have pre created a cluster application and clustered IP address resource and thats why you expect to be able to ping it?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1451202
Posted Thursday, May 9, 2013 9:38 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
no just on the screen where you need to put in the IP address for the network resource during the inital cluster setup, you put in the ip and it won't validate


Post #1451205
Posted Thursday, May 9, 2013 9:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
Are you selecting the correct network from the network list?
Can you post a screenshot of the installer screen with any error messages?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1451209
Posted Thursday, May 9, 2013 9:46 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
here it is I think this is a straightforward issue




  Post Attachments 
iperror.png (5 views, 125.46 KB)
Post #1451215
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse