SQL 2000 Connectivity Problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQL 2000 Connectivity Problem

SQL 2000 Connectivity Problem

Rate Topic

Display Mode

Topic Options

Author

Message

adeel.imtiaz

Posted Tuesday, June 07, 2011 9:52 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 10:54 PM
Points: 42, Visits: 163

Dear All

We have production server in which sql 2000 is installed in cluster enviroment.

We are facing connectivity problem from our application to DB server.

############################################################################################################################################

Timestamp: 2011/06/08 08:31
Message: HandlingInstanceID: d8ff7fc5-cc3a-4137-a508-74d27f773fe4
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
06/08/2011 08:31:01
Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : General network error. Check your network documentation.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 20
LineNumber : 0
Number : 11
Procedure : ConnectionWrite (send()).
Server : 101.52.5.203
State : 0
TargetSite : System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean)
Stack Trace : at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Cap.Persistence.Components.Proposal.QuotationToProposalConverter.GetProposalNo(String companyCode, IDbConnection connection)
Additional Info:
MachineName : WEB01

############################################################################################################################################

TimeStamp : 2011/06/08 12:31
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null
AppDomainName : /LM/W3SVC/1/Root/CAPNetSol-1-129519377566020279
ThreadIdentity : dfl00whjt
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: {cap}
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: WEB01
Application Domain: /LM/W3SVC/1/Root/CAPNetSol-1-129519377566020279
Process Id: 5424
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 5452
Thread Name:
Extended Properties:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

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

############################################################################################################################################

Timestamp: 2011-6-8 8:33:06
Message: HandlingInstanceID: 70cfd9b5-0119-4321-8dbe-a0b945bcfc81
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
06/08/2011 08:33:06
Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : SQL Server does not exist or access denied.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 20
LineNumber : 0
Number : 17
Procedure : ConnectionOpen (Connect()).
Server : 101.52.5.203
State : 0
TargetSite : Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
Stack Trace :
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at WKFIneterfaces.Interfaces.ILoginManager.Login2(UserInfo& uInfo)
at CAPWeb.WKFClass.Login2(UserInfo& uInfo)

Additional Info:
MachineName : WEB01

############################################################################################################################################

TimeStamp : 2011-6-8 0:33:06
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null
AppDomainName : /LM/W3SVC/1/Root/CAPNetSol-1-129519377566020279
ThreadIdentity : dfl00yayh
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: {cap}
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: WEB01
Application Domain: /LM/W3SVC/1/Root/CAPNetSol-1-129519377566020279
Process Id: 5424
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 4952
Thread Name:
Extended Properties:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

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

############################################################################################################################################

Timestamp: 2011/06/08 08:26
Message: HandlingInstanceID: 84708da1-fbbc-43f2-a26d-6af00fa847a2
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
06/08/2011 08:26:49
Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 10
LineNumber : 0
Number : -2
Procedure : ConnectionRead (recv()).
Server : 101.52.5.203
State : 0
TargetSite : System.Data.SqlClient.SqlDataReader ExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean)
Stack Trace : at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at Cap.Persistence.Components.Lookup.DDLProductTypePO.Read2(String strDealerID, String strGroupID, String strProductID, String strAssetMake, String strAssetModel, DataSet data, IDbConnection connection)
Additional Info:
MachineName : WEB01

############################################################################################################################################
TimeStamp : 2011/06/08 12:26
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null
AppDomainName : /LM/W3SVC/1/Root/CAPNetSol-1-129519375336034551
ThreadIdentity : dfl00fsll
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: {cap}
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: WEB01
Application Domain: /LM/W3SVC/1/Root/CAPNetSol-1-129519375336034551
Process Id: 6084
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 4380
Thread Name:
Extended Properties:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

############################################################################################################################################

Thanks
Adeel Imtiaz

Post #1121501