3

I'm working with virtual machine on the windows 8. There is a SQL Server 2008 on the virtual machine. And in the services; when I try to start the SQL Server service getting an error like this:

enter image description here

Can anyone help me?

Thanks.

Edit:

The OS of virtual machine is windows server 2008.

  • Please post the System Event Log message about Sql Server error. Try if exists a service pack on Sql Server 2008 for Windows 8. – Joe Taras Dec 23 '13 at 9:55
  • In the system event log, I found this message: "The SQL Server(MSSQLSERVER) service terminated with service specific error 17058(0x42A2) – bdkhsn Dec 23 '13 at 9:56
  • Have you done what the message states or searched for that error number on the Internet? Otherwise this question does not provide enough information to provide any real help. – Shawn Melton Dec 23 '13 at 9:59
  • @ShawnMelton I searched this error code on the internet, but there is nothing about this code. How can I provide enough information? – bdkhsn Dec 23 '13 at 10:01
  • can you check if your SQL Errorlog file has become read only? I just had this 2 weeks ago and still looking for a root cause. C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG. Btw, this is based on the assumtion that infact your SQL Server was running happily and nobody or nothing has changed anything to the system. Because the error message itself is kind of general..;-) – Edward Dortland Dec 23 '13 at 10:12
2

CHeck for another error in the event log that is time-correlated to this one. Basically - this one is from the service manager. The SQL Server service should have written another error (either into th event log or the errorlog) that contains the internal error that happened. THis error is generic from the serivce manager and as such totally irrelevant to debugging. It also is well known - google for "Sql server 17058" finds tons of references.

It seems to be a permission error:

http://www.it-sideways.com/2012/11/mssql-startup-error-code-17058.html

points to

"Could not open error log file ''. Operating system error = 3 (The system cannot find the path specified.)."

which would be an operating system level configuration or insallation issue.

  • yes it is a permission error. It was about hyper-v management virtual drive configuration. thanks! – bdkhsn Dec 24 '13 at 9:48
0

Yes. You could check that you have all paths configured correctly in this service properties in SQL Server Configuration Manager or Services. This is tab called Startup parameters.

-2

I had already been bothered to explain the solution to this problem. Go to step C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG and clear the file ERRORLOG and then restart the service.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.