We help IT Professionals succeed at work.

SQL Server (MSSQLSERVER) service keeps stopping

3,823 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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012

Commented:
>>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.
J.R. SitmanIT Director

Author

Commented:
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
CERTIFIED EXPERT
Top Expert 2012

Commented:
Under the "Program Files" folder they will both read Microsoft SQL Server.
J.R. SitmanIT Director

Author

Commented:
Thought so.

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
J.R. SitmanIT Director

Author

Commented:
Not a trial version.  Attached are yesterdays logs.
J.R. SitmanIT Director

Author

Commented:
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
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
J.R. SitmanIT Director

Author

Commented:
Attached is todays log.  At the bottom it stopped.  Please advise what to do.

Thanks
sql0507.txt
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
J.R. SitmanIT Director

Author

Commented:
Still no luck.  What if I uninstall SQL Express and install SQL Express with advanced features?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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.
J.R. SitmanIT Director

Author

Commented:
Thanks, I'll get back to you.
J.R. SitmanIT Director

Author

Commented:
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.
J.R. SitmanIT Director

Author

Commented:
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
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
J.R. SitmanIT Director

Author

Commented:
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
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
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
J.R. SitmanIT Director

Author

Commented:
MSXML won't uninstall.  I get "fatal error during installation"  What should I do?

Thanks for sticking with me on this.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
J.R. SitmanIT Director

Author

Commented:
Thanks for your help and patience

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.