Re: Problem with starting SQL Server 2000

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 09/21/04


Date: 21 Sep 2004 10:07:43 -0700

Hi

Googling for this error message seems that you have something pretty
seriously wrong such as a hardware error. You may want to call PSS to
see if they can help such as:

http://tinyurl.com/44cny

John

Butt Chin Chuan <ButtChinChuan@discussions.microsoft.com> wrote in message news:<EA109930-51D0-4EFE-82C8-6C5E6F6F147B@microsoft.com>...
> I got this message from C:\Program Files\Microsoft SQL Server\MSSQL\LOG,
> please kindly inform me what it means, thank you :
>
> 09/02/03 15:47:52 spid 0 Exception 0x400042ac PRINTSTACK at 0x77E9E8BB
> 10/06/03 20:33:24 spid 0 Exception 0x400042ac PRINTSTACK at 0x77E9E8BB
> 11/08/03 04:04:06 spid 0 Exception 0x400042ac PRINTSTACK at 0x77E9E8BB
> 12/03/03 15:44:03 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/04/03 16:25:19 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/04/03 16:40:50 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/05/03 21:19:47 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/06/03 02:14:38 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/10/03 11:50:13 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/10/03 18:09:08 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/11/03 13:23:30 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/12/03 01:13:12 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/12/03 07:04:24 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/12/03 07:12:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/13/03 06:15:20 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/13/03 15:52:24 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/14/03 06:23:53 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/14/03 13:57:08 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/14/03 20:29:51 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/15/03 11:27:47 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/16/03 09:09:39 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/17/03 09:33:58 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/17/03 09:44:25 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/18/03 08:36:58 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/18/03 10:46:25 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/19/03 10:41:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/20/03 03:20:59 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/21/03 11:07:30 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/21/03 12:45:05 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/21/03 13:46:20 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/22/03 10:26:11 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/24/03 10:40:03 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/25/03 10:46:48 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/26/03 04:41:20 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/26/03 18:19:27 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/26/03 18:48:26 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/30/03 21:08:40 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 12/31/03 09:58:53 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/01/04 11:10:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/03/04 13:04:30 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/07/04 23:24:53 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/07/04 23:30:43 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/08/04 17:51:15 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/09/04 18:30:04 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/10/04 01:22:06 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/12/04 17:49:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/12/04 22:31:51 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/12/04 22:50:39 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/12/04 23:04:19 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/15/04 11:58:40 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/16/04 11:30:26 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/19/04 20:19:53 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/26/04 13:24:50 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/27/04 14:04:44 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:42:34 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:53:12 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:53:54 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:54:25 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:54:32 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:54:44 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:54:50 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/28/04 13:55:33 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/29/04 12:07:50 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 01/30/04 12:49:47 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/01/04 17:17:25 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/03/04 12:31:14 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/06/04 22:34:33 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/07/04 22:40:43 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/09/04 14:35:41 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/10/04 11:48:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/12/04 05:09:23 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/13/04 21:30:04 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/16/04 15:40:26 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/18/04 15:54:43 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/25/04 14:56:38 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/26/04 10:30:23 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 02/26/04 15:19:05 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/03/04 09:59:59 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/04/04 21:13:40 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/06/04 20:47:11 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/07/04 19:18:26 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/09/04 22:21:58 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/10/04 10:58:46 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/10/04 22:15:35 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/19/04 11:00:12 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 03/27/04 13:42:20 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 04/01/04 11:28:45 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF888D1
> 04/19/04 20:41:33 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 04/24/04 17:33:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 05/04/04 15:11:10 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 05/04/04 15:13:29 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 05/12/04 14:07:08 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 05/29/04 03:56:55 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 05/29/04 03:59:14 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 06/01/04 11:47:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 06/05/04 11:32:11 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 06/21/04 12:42:32 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 08/03/04 00:41:23 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 08/04/04 10:10:14 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x6DF89BAF
> 08/17/04 15:18:23 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 08/24/04 12:07:40 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/06/04 11:51:44 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/09/04 17:47:57 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/09/04 23:17:20 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/20/04 01:43:32 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26629BAF
> 09/20/04 01:47:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26639BAF
> 09/20/04 01:48:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26639BAF
> 09/20/04 01:48:24 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x264B9BAF
> 09/20/04 01:48:36 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26639BAF
> 09/20/04 01:53:22 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26609BAF
> 09/20/04 01:59:02 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26629BAF
> 09/20/04 02:01:54 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26609BAF
> 09/20/04 02:04:28 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/20/04 02:05:03 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x263E9BAF
> 09/20/04 02:05:05 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26569BAF
> 09/20/04 02:05:44 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26589BAF
> 09/20/04 02:06:34 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26589BAF
> 09/20/04 02:06:37 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26409BAF
> 09/20/04 02:09:54 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26589BAF
> 09/20/04 02:11:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26409BAF
> 09/20/04 02:14:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x265A9BAF
> 09/20/04 02:34:21 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at
> 0x26589BAF
>
> "John Bell" wrote:
>
> > Hi
> >
> > It sounds like your SQL Server service has not started, as Agent is
> > dependent on this service it will fail to start as well.
> > You should have some information in the SQL Server error log file and the
> > event log detailing why it did not start. (see Viewing Error logs in books
> > online for their location)
> >
> > Re-installing SQL Server should not be necessary, but you will be able to
> > re-attach the databases once the new installation is configurered. If you
> > are really stuck you could create a second instance and attach the data and
> > log file to it (maybe copying the files first!).
> >
> > HTH
> >
> > John
> >
> > "*** Chin Chuan" <*** Chin Chuan@discussions.microsoft.com> wrote in
> > message news:D1B3F141-24E7-4734-9B0C-61FA62A8030F@microsoft.com...
> > > I got an extremely serious problem with SQL Server 2000 now.
> Without
> > > it, I couldn't start SQL and continue my programming work in SQL CE(I need
> > > both). Please kindly give me some help concerning the problem below:
> > >
> > > 1. When my pc starts, sometimes the SQL Server and the SQL Server Agent
> > > doesn't start. Usually this can be solved by restarting the pc again or
> > > manually start it by going through the SQL Server Entreprise Manager.
> > >
> > > 2. However, this time, I couldn't settle this problem, when i start with
> the
> > > SQL Server Agent in the taskbar (the small icon), it gives me this
> message:
> > > An error 1068 - (The dependency service or group failed to start) occured
> > > while performing this service operation on the SQLServerAgent service.
> > >
> > > 3. Then I tried to start in the SQL Server Entreprise Manager, and got
> this
> > > error message:
> > > A connection could not be established to BUTT2000.
> > > Reason: SQL Server does not exist or access denied.
> > > ConnectionOpen(Connect())..
> > > Please verify SQL Server is running and check your SQL Server registration
> > > properties (by right-clicking on the BUTT2000 node) and try again.
> > >
> > > 4. Next, I tried to change login from needing the username and password to
> > > Windows Authentication, but I got this error message instead:
> > > SQL Server registration failed because of the connection failure displayed
> > > below. Do you wish to Modify anyway?
> > > SQL Server does not exist or access denied.
> > > ConnectionOpen (Connect()).
> > >
> > > * Note:
> > > My Operating System = Windows 2000 Server
> > > Functions running when pc start = Microsoft Search, Distribution
> Transaction
> > > Coordinator
> > > Functions not running when pc start = SQL Server, SQL Server Agent
> > >
> > > From the above error messages, I assumed that this
> > > ConnectionOpen(Connect()) method is the cause of my problem(not sure, but
> it
> > > is my assumption only). Before this problem occurs, what I did is just
> > > restarting my pc, without download or updating or installing anything. And
> > > prior to my pc restart, the SQL Server is working fine. Could someone
> please
> > > point out what is cause of the problem and the solution to it?
> > >
> > > I haven't backup my SQL data for ages. If i am to uninstall and
> > > install again the SQL Server 2000, together with Service Pack 3 with it,
> will
> > > my data be preserved? I personally would like to solve this problem in
> other
> > > means instead of reinstall the SQL Server 2000, as I am worry my data will
> be
> > > lost and alot other settings that I need to configure again...
> > >
> > > That's all for my problem description. I sincerely hope someone
> can
> > > help me with this problem, as I couldn't do anything else at the moment
> > > without this SQL Server 2000 up and running.
> > >
> > > Yours Faithfully,
> > > *** Chin Chuan
> >
> >
> >