MSDE service manager just stops???

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
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
|||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:
[vbcol=seagreen]
> Have you looked in the event log for errors?
> "GREGO" wrote:
|||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...[vbcol=seagreen]
> 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:
MSDE[vbcol=seagreen]
installed as i use the Enterprise manager to work on my database.[vbcol=seagreen]
stops and i cant get it to restart. and the only way is to uninstall it and
reinstall.[vbcol=seagreen]
to get that working.[vbcol=seagreen]
(work experience) but i spend so much time keeping my shonky system
running i loose time in developing.[vbcol=seagreen]
sql DB at home, or am i flogging a dead horsse.[vbcol=seagreen]

MSDE installation messes up Query Analayzer and Enterprise Manager

Does anyone out there know how to fix the problem with the SQL tools and MSDE?
I have found that if you install MSDE after installing SQL Server's Tools
the tools don't work anymore. Any help or suggestions here would be
appreciated.
Try reapplying latest service pack.
"jdehne" <jdehne@.discussions.microsoft.com> wrote in message
news:8E64752E-84F1-462D-A614-2E6CCF943300@.microsoft.com...
> Does anyone out there know how to fix the problem with the SQL tools and
> MSDE?
> I have found that if you install MSDE after installing SQL Server's Tools
> the tools don't work anymore. Any help or suggestions here would be
> appreciated.