Re: SP1 does not work
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/21/04
- Next message: Mr. A: "Cannot install SQL Server 2000 on Server 2003"
- Previous message: Tibor Karaszi: "Re: Installing Multiple Versions of SQL Server"
- In reply to: AA: "SP1 does not work"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 13:23:24 +0200
Perhaps you hit some other bug then the one referred to in SP1? I suggest you open a case with MS Support for
this.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "AA" <not@noreply.com> wrote in message news:e$OO5w3JEHA.208@tk2msftngp13.phx.gbl... > This mail is regarding a trouble I'm facing with SQL Server 2000. I'm > working with ASP .NET V 1.1 and SQL Server 2000. I have a reporting module > that generates XML reports from the SQL Server 2000 database. Things are > fine and running, but at times I get a fatal SQL Server Exception when I > access reports continuously. That is, this error occurs after I generate a > report and immediately invoke another report. But the same process works > without any problem some other time! > The exception says" Process 55 generated fatal exception c0000005 > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."? > > > > Searching the cause of this bug, I learnt that the fix for this SQL bug is > in SQL Server 2000 Service Pack 1. I installed it, but the error is still > there. I tried service pack 3 also, but of no use. I also tried connecting > to the database by setting "pooling=false" in the connection string so that > every time I go to the database with a new connection. I did this thinking > that it might be a corrupted connection in the pool which is creating the > error, but of no effect. > > > > From the error, I can assess that it's an unmanaged memory violation > exception that is occurring at the server. I also doubt whether it's any > deadlock occurring at the server when the current connection tries to access > the resource occupied by a previously unclosed connection in the database. > > > > I also got one more misleading error in the same context, which says > "General Network Error. Please check your network documentation". I wonder > whether this error is related to the previous bug. > > >
- Next message: Mr. A: "Cannot install SQL Server 2000 on Server 2003"
- Previous message: Tibor Karaszi: "Re: Installing Multiple Versions of SQL Server"
- In reply to: AA: "SP1 does not work"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
