SQL Service will not start. I am getting an error 17058.

Richard Comito
Richard Comito used Ask the Experts™
on
I have a SQL Server that has been working fine for the past year.  But all of a sudden when I rebooted my server I got this error:

"The SQL Server (TESSI2005) service terminated with service-specific error 17058 (0x42A2)."

 Everything that I have read says that SQL is corrupt and I need to reinstall.  Is there something else I can do to keep from re-installing my SQL.

Thanks,

Gabicus
SQL-Server-service-Startup-error.bmp
sqlservr.exe-error.bmp
System-Event-Error.txt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
First check the SQL error log going to the log folder and open it in notepad and see if there is any hint...
if not then check the application/system log...as per the screen shot it is complaining the about the binaries...
Make sure system db folder and binaries and log folder available and it was not renamed..
and make sure SQL server service account has the permissions to the folder if the folder exists and nothing got changed...
Richard ComitoDirector of IT

Author

Commented:
MohammedU,

Thanks for the reply.  I checked the error log file and did not see anything that would help.  I then checked the application/system log and got this message.

UpdateUptimeRegKey: Operating system error 5(Access is denied.)

Do I need to go and make a change to the registry?
Is that registry error source is SQL server?
Make sure SQL Server service account has the access or atleast make service account to member of local admin group...
Any other errors related to SQL?
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Richard ComitoDirector of IT

Author

Commented:
Yes the source is the SQL Server.

I have double check that the login is part of the Local Admin group.

And there are two errors that I was getting one was cannot start error log file and the second is the registry issue.  Here are the full Event Properties.  
Application-System-Log-reg.txt
Application-System-Log-Cannot-Op.txt
Richard ComitoDirector of IT

Author

Commented:
MohammedU,

I got it to work.  Very strange.  It was the admin permission issue.  The account that I use on this is the same account that I have used for the past year.  I guess I will have to work on why this is not working on my end with my network guy.  We are using a domain account on this server.

thanks,

Gabicus
I had a very similar issue with the following error (event log):

Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error 17058 (0x42A2).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17058
Date:            19/05/2012
Time:            10:20:14
User:            N/A
Computer:      NSQLXX
Description:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found).
------------------------------------------------------------

In this case the ERRORLOG file had been marked as read only. This was following a scheduled automated boot.

MSSQL wouldn't not start until this file had been changed.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial