| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2007-04-10 : 06:24:16
|
| if someone has an idea of what this error is about please help...Network Name <SQL Network Name (node1)>: Unable to read ResourceData parameter, error=200000cd0.0000139c::2007/04/06-12:05:32.640 WARN Network Name <SQL Network Name (node1)>: Unable to read CreatingDC parameter, error=2this is the network name resource and it fails to go online...the names and ip addresses are unique although the we have 3 interfaces and the public network is configured for dhcp...another question, can we modify the network interface information directly? any special procedures?any help appreciated... PS, Tara, have you encountered this before?TIA--------------------keeping it simple... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-10 : 10:23:34
|
| Is sql ip address resource running? Is sql network name map the that ip address correctly in wins and/or dns? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-04-10 : 14:13:12
|
yes for both questions...i did an nslookup as well and forced dns replication, just to make sure it resolves the namequote:
Originally posted by rmiao
Is sql ip address resource running? Is sql network name map the that ip address correctly in wins and/or dns?
--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 10:05:52
|
| Did you check cluster log file? What's OS version and sp level? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-04-11 : 10:37:15
|
| yes I did, that's where the error messages I posted came from.I'd like to know what the message means, is it trying to resolve the network name and unable to do so? Is there inconsistency on the registry and cluster config file or settings, what is error 2?have you encountered this before? does OS sp2 resolve this type of error? TIA--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 11:25:29
|
| No, I never had that on my clusteres. I'll try set static ip address for all NICs in this case. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-04-11 : 12:17:23
|
| yes, i tried that too but still no luck in getting the resource up...what does unable to read creatingDC parameter, error=2 mean?--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-11 : 13:58:46
|
| Can't find useful info anywhere. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-04-11 : 16:16:53
|
thanks for your time, if nothing comes up, i would probably evict and rejoin the node, which may mean, i need to reinstall mssql as well --------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-12 : 11:08:39
|
| You can run sql install again to add node to sql cluster. Not complete reinstall sql, but need reapply sp. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-04-13 : 01:42:58
|
| funny thing though, the test cluster doesn't want to fail no matter what I do with it, change parameter values, shutdowns, etcthere must be some documentation out there, if anyone could be so nice to redirect me I'd appreciate it very very much...muchos gracias!--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-13 : 10:32:38
|
| You mean it didn't failover to another node? |
|
|
|
|
active/active problem