SQL Service stops automatically

OK, I will check.

also there is one errorlog for sql srver agent

http://msdn.microsoft.com/en-us/library/ms191008(SQL.90).aspx

I will take a look at that too. Of course, given I have to remote into her machine or ask her to provide me the info, it will take until tomorrow.

Are there any updates available for SQL Express that could cause this if they weren't installed?

It stops every day at 5:45PM to 6:15PM.

I would agree it sounds as though something is scheduled for that time. Again, I have to check with her which delays this process.

I just looked at the updates to SQL Server Express, and I am still on SP2. Do you think SP3 would work better, and would it possibly fix the problem?

Not to confuse you, but even though mine is working fine with SP2, is it advisable to download and install the Service Pack 3?

>> Do you think SP3 would work better, and would it possibly fix the problem?

Not sure.. But its recommended to stay with Latest Service packs for all Microsoft products.
Hence give it a try too.

I don't think these are the logs you wanted. I asked for the error and warning messages from the event viewer for applications and system.

Does this help at all?

Aneesh asked to provide the event viewer logs since Service starts or stops would be mentioned over there.

Kindly check in event viewer around this time 5:45PM to 6:15PM to identify whether your SQL Server is stopping abruptly or some process is doing it out.

I know. I am at the mercy of those who are less computer literate than I. I asked for the event viewer information and was given the above. They were advised to do this by a supposedly intelligent SQL Server IT person.

I will keep working on it. One thing they did say was they noticed that a certain SQL Server update kept trying to install but was unable to and on one person's machine, this seemed to correspond to the time of the issue. Supposedly, it kept trying to reinstall itself everyday.

>> they noticed that a certain SQL Server update kept trying to install but was unable to and on one person's machine, this seemed to correspond to the time of the issue.

Kindly let me know the service pack you are in currently.
To check this, run the one below:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I couldn't locate where that was.

In Add/Remove programs, I could only find SP3 update for SQL Server 2005 Tools and Components.

I asked you to run the query in SSMS to find your Service pack information.
Kindly run that code in SSMS and revert with the results.

rrjegan17,

I appreciate your help. But, I looked back through your posts and nowhere does it say run the query in SQL Server Management Studio. I suppose I should recognize that SELECT SERVERPROPERTY, etc. is a query in SSMS, but I am a beginner.

Also, I am one of the very few who has an sa and password for this instance and you can't log in using Windows Authentication. So, the ones I am trying to help would have no way to use the studio to get to the instances.

Why do I need to run all three queries to get the version? Remember, I don't mind sharing that I am new to SQL. I generally don't have a need to run queries so I tend to forget how to do it anyway. I'm a little surprised that the version number isn't in an easier place to find anyway.

The same thing happened when Aneesh asked for the logs. I even said these weren't the right logs. Maybe I shouldn't try to help people by looking for the answer on EE. It is certainly more difficult for me and the experts. But, I don't feel that bad, because I still get back quickly with the results, I always give 500 points generally with an A, and I still learn a lot in the process. Everyone is happy.

>> But, I looked back through your posts and nowhere does it say run the query in SQL Server Management Studio.

I am not aware that you are a beginner..
And usually everyone will try running the queries in SSMS using their credentials and thought you would have been aware of..
Again we would refer SSMS for SQL Server Management Studio only.

Running that query confirms your Database Engine version and applying the latest Service packs might help some timesm.

Thanks. I will take that as a compliment. I am sure it is difficult on here because it is hard for the experts to know whether we know where the start button is or how to set up a terminal server with SBS. (Although I am not really sure that is that hard). Plus, you are a genius so you may forget how difficult it was. I do the same things as a doctor words like volvulus when I should be saying "your stomaching twisting."

It is even more difficult, because I am a little better than a beginner, and I am trying to relate the info to complete beginners. I almost didn't ask the question because of that.

But in the long run it was helpful for them, and I learned something even if were the queries.

Thanks for all of your help.

Here are the application and system logs. The application log seems to only give error messages about the POP3 Connector.

Welcome..
And you have lot many errors for POP3 events..
Can you click on any one event and post the entire error message so that we can analyze on that..