Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Question Unanswered: getting time out errors in Session database in SQL 2005

    Hi,

    I have a web applicaition on .net framework 1.1
    I've migrated my SQL database from SQL 2000 to SQL 2005 server.

    Now i'm getting the below error

    [SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
    System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, TdsParserState state) +164
    System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning() +678
    System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected) +499
    System.Data.SqlClient.TdsParser.ReadBuffer() +99
    System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32 offset, Int32 len) +145
    System.Data.SqlClient.TdsParser.ReadValue(_SqlMeta Data md, Int32 length) +352
    System.Data.SqlClient.TdsParser.ProcessRow(_SqlMet aData[] columns, Object[] buffer, Int32[] map, Boolean useSQLTypes) +244
    System.Data.SqlClient.SqlDataReader.PrepareRecord( Int32 i) +166
    System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) +27
    System.Data.SqlClient.SqlDataReader.get_Item(Int32 i) +5
    System.Web.SessionState.SqlStateClientManager.DoGe t(String id, SqlCommand cmd) +422

    [HttpException (0x80004005): Unable to connect to SQL Server session database.]
    System.Web.SessionState.SqlStateClientManager.DoGe t(String id, SqlCommand cmd) +535
    System.Web.SessionState.SqlStateClientManager.GetE xclusive(String id) +81
    System.Web.SessionState.SqlStateClientManager.Syst em.Web.SessionState.IStateClientManager.BeginGetEx clusive(String id, AsyncCallback cb, Object state) +6
    System.Web.SessionState.SessionStateModule.GetSess ionStateItem() +67
    System.Web.SessionState.SessionStateModule.BeginAc quireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +274
    System.Web.AsyncEventExecutionStep.System.Web.Http Application+IExecutionStep.Execute() +66
    System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +173

    I'm using SQL server mode for seesion management
    Can you please advice on this ASAP?

    My web.config settings for the session are
    <sessionState
    mode="SQLServer"
    sqlConnectionString="data source=asdfasdf ;user id=ASPState;password=@SPstate;Connection Lifetime=400;"
    cookieless="false"
    timeout="600"
    />



    Thanks,
    Rumit

  2. #2
    Join Date
    Dec 2007
    Posts
    11
    Have you enabled the TCP/IP protocols in Surface area configaration ?

  3. #3
    Join Date
    Mar 2009
    Posts
    3

    Hi.

    Hi, thanks for your reply,
    But i'm working on .Net and i'm not aware of database part. We have DBAs team separatley for this. Should i ask DBA directly what your suggesting?

  4. #4
    Join Date
    Mar 2009
    Posts
    3

    hi

    Hi also im new to .net,
    can you please explain excatly what i have to do?
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •