Re: MSDE service manager just stops??????

From: J Young (thorium48_at_hotmail.com)
Date: 06/15/04


Date: Mon, 14 Jun 2004 22:52:26 -0700

The SQL Server log is just a text file under the SQL Server directory,
normally in the LOG directory. Load the most recent one into Notepad and see
if there are any errors.

Jim

"GREGO" <GREGO@discussions.microsoft.com> wrote in message
news:B074205A-A3A6-48DB-8EBB-350E3118AFDE@microsoft.com...
> Do you mean the windows event log?
>
> i cant access the SQL server log as it is shut down and i cant access it
>
> regards
> greg
> "Nigel Rivett" wrote:
>
> > Have you looked in the event log for errors?
> >
> > "GREGO" wrote:
> >
> > > HI every one
> > >
> > > I hope i dont sound too dumb here but i am having some problems with
MSDE
> > >
> > > I have it installed on my local machine and SQL server 2000 is also
installed as i use the Enterprise manager to work on my database.
> > >
> > > I dont have server software as my OS is win XP pro.
> > >
> > > The problem i have is that after a while the MSDE service manager just
stops and i cant get it to restart. and the only way is to uninstall it and
reinstall.
> > >
> > > i have tried to get the 2000 MSDE installed but i seem to not be able
to get that working.
> > >
> > > It is frustrating as i am developing a databse at home for a client
(work experience) but i spend so much time keeping my shonky system
running i loose time in developing.
> > >
> > > is there somewhere i can learn to set my system up so i can develop a
sql DB at home, or am i flogging a dead horsse.
> > >
> > > any help greatly appreciated
> > >
> > > Greg



Relevant Pages

  • Re: SPS2003 SQL Database sizes?
    ... whether the sql server log file grows and to what extent is mainly ... determined by the recovery mode of the sql server. ... database from backup the you can only do so from your last FULL backup - ...
    (microsoft.public.sharepoint.portalserver)
  • 17805 Starting up Java App server, with SQL Server 2000 Backend
    ... I go to the SQL Server log and I see an ... declare @P1 int ... On another machine running SQL Server 2000 Standard on Win2K advanced, ...
    (microsoft.public.sqlserver.clients)
  • Re: login failed because it is not associated with a trusted connection
    ... The SQL Server log? ... created on a veritas backup exec 10.0 box so that I can pull data from ... I have also used a full install of sql server using enterprise manager ...
    (microsoft.public.sqlserver.msde)
  • Re: Login failed for user (null)
    ... sql server log file? ... public access to Northwind. ... The same user can connect to another SQL server using Windows ...
    (microsoft.public.sqlserver.security)
  • RE: MSDE service manager just stops??????
    ... Do you mean the windows event log? ... i cant access the SQL server log as it is shut down and i cant access it ...
    (microsoft.public.sqlserver.msde)