Cannot Get To EventViewer
Jun 22, 2007
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 Edition
SQL Server 2000 with SP4
SQL Server 2005 Client Tools
Thanks
View 3 Replies
Oct 20, 2007
Hi,
we have a active/passive cluster server with SQL server 2005 SP2 installed.
i have found the following error messages in event viewer application log for MSSQLServer:
1) [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.
2) [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
3) [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
4) [sqsrvres] OnlineThread: QP is not online.
can any one pls help me finding out the solutions.
Thanks in Adv,
Praneetha.:)
View 1 Replies
View Related
Oct 10, 2006
hi all,
i searched and all i found is questions, not answers.
maybe it's a silly question, but i really can't find any documention / posts about this.
i have a scheduled job in sqlagent that executes a SSIS package that runs every minute. As a result, my application log in eventviewer gets filled very quickly.
i tried using "/REPORTING E" option with no luck.
i tried enabling logging on the package, and then select only the OnErro Event, no luck.
does anyone have this problem ?
does anyone have a solution ?
TIA
View 4 Replies
View Related