Solved

SQL Server (MSSQLSERVER) service keeps stopping

Posted on 2009-05-06
21
1,752 Views
Last Modified: 2012-06-22
I have one of our XP workstations that the SQL Server service keeps stopping.  I set the properties to restart it on the 1st and 2nd failure, but it continues to happen.  Is there a fix?  Also how can I determine if I've applied the latest SQL Express patch to a workstaion?

Thanks
0
Comment
Question by:J.R. Sitman
  • 12
  • 7
  • 2
21 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24314848
>>Also how can I determine if I've applied the latest SQL Express patch to a workstaion?<<
Check the build with SELECT @@VERSION or SELECT SERVERPROPERTY('ProductLevel') and compare to the latest build available for that specific version.
0
 

Author Comment

by:J.R. Sitman
ID: 24315934
Just to be sure, when you open Programs on a workstation, if it states SQL Server is that the full version or could it also be SQL Express
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24317603
Under the "Program Files" folder they will both read Microsoft SQL Server.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:J.R. Sitman
ID: 24317613
Thought so.

0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24320756
Might be because of the following reasons too:

1. Check that the account that has been assigned for the service ("Log On" tab in the property window of the service). If you have specified an account for this, make sure that correct password has been set.

2.This error occurs if you are using an evaluation copy of SQL Server and the evaluation period is over. To determine if this is cause of the error, check the error log at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG (this is the default). You should find the string  "SQL Server evaluation period has expired".

If above two are not satisfying your scenario provide the error Information from Event Monitor so that it can be tracked out accordingly.
0
 

Author Comment

by:J.R. Sitman
ID: 24320921
Not a trial version.  Attached are yesterdays logs.
0
 

Author Comment

by:J.R. Sitman
ID: 24321012
sorry hit submit too soon.  rename it to .zip.  also rename all the .txt in the file to .trc  Rename the error logs to .log

sqllogs2.txt
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24321217
Have seen this error messages in the logs attached:

Login failed for user 'sa'

Kindly reset the sa password and try restarting all services of SQL Server. Hope this would help you to solve your problem.
0
 

Author Comment

by:J.R. Sitman
ID: 24325887
Attached is todays log.  At the bottom it stopped.  Please advise what to do.

Thanks
sql0507.txt
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24352749
Try this one out:

http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/a8fbf8d6-9949-47a5-a32b-50f8131f1127/

Hope you are using SQL Server Express edition as you mentioned << latest SQL Express patch to a workstaion >> earlier.
0
 

Author Comment

by:J.R. Sitman
ID: 24387075
Still no luck.  What if I uninstall SQL Express and install SQL Express with advanced features?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24392655
Give it a try by installing SQL Express with Advanced Features too.

Do you have the backups of all databases?
Make sure you backup all your databases before uninstalling.
0
 

Author Comment

by:J.R. Sitman
ID: 24393828
Thanks, I'll get back to you.
0
 

Author Comment

by:J.R. Sitman
ID: 24398996
It's worse.  I unistalled SQL 2005 and tried a reinstall and it failed.  I did a system restore and that didn't work either.  When I tried to uninstall SQL through add/remove it wouldn't remove the SQL server.  I know there is a program that will force an uninstall.  Any help would be appreciated.
0
 

Author Comment

by:J.R. Sitman
ID: 24399934
I did an uninstall successfully.  However the new install fails.  PLEASE review the attached logs.  I'm desperate.  The workstation is used for running our POS system.

Thanks
sqlspcala17.zip
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24401984
I hope your uninstallation would have ended up in some other issues.
Try uninstalling it manually once:

http://www.sql-server-performance.com/faq/How_to_Manually_Uninstall_SQL_Server_2005_p1.aspx

If the above folder was removed during uninstallation, then try the one below

http://www.crucialp.com/blog/2008/02/26/how-to-uninstall-ms-sql-server-2005-manually/

If you face any issues, then try this one out
http://support.microsoft.com/kb/909967
0
 

Author Comment

by:J.R. Sitman
ID: 24403348
I did all the manual steps descriped in the links above.  After rebooting I tried to install SQL2005 Advanced.  It still failed.  Attached are the logs.

Thanks for helping.  I haven't given up yet, but I close.
sqllogs051609.zip
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24405015
Ok. Try out the below things:

1. Uninstall the existing incomplete installation.
2. Uninstall MSXML 6 from your system.
3. Install the prerequisites for SQL Server 2005 like Dot net framework
http://www.microsoft.com/DownLoads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en\

Looks like something was corrupted.

4. Install SQL Server 2005
0
 

Author Comment

by:J.R. Sitman
ID: 24406680
MSXML won't uninstall.  I get "fatal error during installation"  What should I do?

Thanks for sticking with me on this.
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 500 total points
ID: 24410368
Ok.. Missed to inform about this earlier itself.
To uninstall MSXML you have to use Windows Installer Cleanup Utility given below:

http://support.microsoft.com/kb/290301

Also uninstall any incomplete installations of SQL Server too.

Now give it a try and this should solve your problem.
0
 

Author Closing Comment

by:J.R. Sitman
ID: 31578462
Thanks for your help and patience
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 46
Convert formula to max at a specific date by month 18 22
sql 2014,  lock limit 5 34
T-SQL: Do I need CLUSTERED here? 13 48
Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question