SQL 2000 Connectivity Problem

  • 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

  • Dear All,

    Can some one help me in above issue.

    Thanks

    Adeel Imtiaz

  • 1, check firewall setting

    2, DNS

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply