November 18, 2008 at 2:07 am
windows 2003 server enterprise x64 Sp2 (clustered w/ active/passive)
sql server 2005 Sp2
managed to connect to database from local (on the database server itself) at the beginning.
however, after 10 mins, when i try to run the same query (by pressing F5), i got error below:
A transport-level error has occurred when sending the request to the server.
then, i re-connect to the server and run the query without problem.
this happens a few times in a day. server was not busy at all when this error occurs.
does anyone has any idea on this?
thanks. 🙂
November 18, 2008 at 2:34 am
Leo Leong (11/18/2008)
windows 2003 server enterprise x64 Sp2 (clustered w/ active/passive)sql server 2005 Sp2
managed to connect to database from local (on the database server itself) at the beginning.
however, after 10 mins, when i try to run the same query (by pressing F5), i got error below:
A transport-level error has occurred when sending the request to the server.
then, i re-connect to the server and run the query without problem.
this happens a few times in a day. server was not busy at all when this error occurs.
does anyone has any idea on this?
thanks. 🙂
did you check the network
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 18, 2008 at 2:58 am
thanks for reply. 🙂
I found this in my event viewer:
-- ========================================================
Event Type:Error
Event Source:ClusDisk
Event Category:None
Event ID:1209
Date:11/18/2008
Time:12:46:08 AM
User:N/A
Computer:ServerName_of_PassiveNode
Description:
Cluster service is requesting a bus reset for device \Device\ClusDisk0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 0e 00 00 00 01 00 5a 00 ......Z.
0008: 00 00 00 00 b9 04 00 00 ....¹...
0010: 41 52 73 74 00 00 00 00 ARst....
0018: 00 00 00 00 00 00 00 00 ........
0020: 00 00 00 00 00 00 00 00 ........
-- ========================================================
Event Type:Error
Event Source:ClusSvc
Event Category:Membership Mgr
Event ID:1176
Date:11/18/2008
Time:12:46:19 AM
User:N/A
Computer:ServerName_of_ActiveNode
Description:
Cluster service is shutting down as requested by node 2 (ServerName_of_PassiveNode). Check the system event log on node 2 to determine the reason for the shutdown request. Cluster service will restart per the Service Manager's recovery actions.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
-- ========================================================
Could this be the root cause?
May i know how can I resolve this?
thanks. 🙂
November 18, 2008 at 3:11 am
Leo Leong (11/18/2008)
thanks for reply. 🙂I found this in my event viewer:
-- ========================================================
Event Type:Error
Event Source:ClusDisk
Event Category:None
Event ID:1209
Date:11/18/2008
Time:12:46:08 AM
User:N/A
Computer:ServerName_of_PassiveNode
Description:
Cluster service is requesting a bus reset for device \Device\ClusDisk0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 0e 00 00 00 01 00 5a 00 ......Z.
0008: 00 00 00 00 b9 04 00 00 ....¹...
0010: 41 52 73 74 00 00 00 00 ARst....
0018: 00 00 00 00 00 00 00 00 ........
0020: 00 00 00 00 00 00 00 00 ........
-- ========================================================
Event Type:Error
Event Source:ClusSvc
Event Category:Membership Mgr
Event ID:1176
Date:11/18/2008
Time:12:46:19 AM
User:N/A
Computer:ServerName_of_ActiveNode
Description:
Cluster service is shutting down as requested by node 2 (ServerName_of_PassiveNode). Check the system event log on node 2 to determine the reason for the shutdown request. Cluster service will restart per the Service Manager's recovery actions.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
-- ========================================================
Could this be the root cause?
May i know how can I resolve this?
thanks. 🙂
This problem occurs from SQL 2005 onwards,
Possible Solutions:
* Install latest updates for OS as well as SQL Server 2005 after install the SQL 2005 sp2.
* install latest hot fixes for SQL Server 2005.
* some times this problem for SQL Native Client, possible re-install the SQL Native Client.
* repair the .NET framework 2.0 with sp's.
Also check the below links:
http://support.microsoft.com/kb/942861
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1628211&SiteID=1
http://support.microsoft.com/kb/925843 - for Hot fixes.
November 18, 2008 at 3:31 am
thanks for the suggestions. 🙂
I will contact my system admin to try it out.
Once I got the result, I will post it here.
thank you, again. 🙂
August 24, 2009 at 9:38 am
any updates on this...?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply