Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
plsntnrules
Starting Member
2 Posts |
 Posted - 2007-06-22 : 12:10:34
|
| I am trying to get to the event viewer for the SQL Network name.This is terminology that is used when SQL is clustered.So essentialy u have the node name which is ServerA and ServerB and then you have the SQL Network Name which in this case is ServerX.So I can RDP to the SQL Network Name which is ServerX. i can do most everything. When I bring up the event viewer I can view it just fine but that is because it defaults to the active node.What I am trying to do is to get to the event viewer for the SQL Network Name. And the way I do it on other clusters is I bring up Computer Management, right click on Computer Management and slect "Connect to another computer". I type in the name of the SQL Network Name, ServerX and I am presented with the computer management for ServerX. But when I try to expand the Event Viewer I get the following error.."Unable to connect to the computer "ServerX". The error was: The network path was not found."I guess getting to the event viewer for the SQL Network Name is important for the DBAs.Has anyone come across this?Windows Server 2003 Enterprise x64 EditionSQL Server 2000 with SP4SQL Server 2005 Client ToolsThanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-22 : 15:19:13
|
| If cluster name is in dns or wins, should be able to connect to it. If not, you can use ip address. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-22 : 15:21:01
|
| For clusters when you connect to Event Viewer, it brings up all events on all cluster groups and nodes. So you don't need to use SQL Network Name. If either of the node names works, then use that instead. Regardless of what you use, you'll see the same information.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
plsntnrules
Starting Member
2 Posts |
Posted - 2007-06-22 : 15:54:26
|
| Thanks rmiao..I can connect using the IP of the sql network name..Just not the dns name...Weird..Using nslookup I can successfully resolve the sql network name to the same IP.Tara...yes I know what you have suggested but my issue is that on a separate cluster I can do the exact same and can successfully connect but cant do so on this cluster. And I am afraid this could mean there are other issues with the cluster that are not readily apparent. |
|
|
|
|
|
|
Cannot get to EventViewer