thanks, Gabicus 0 LVL 1 Overall: Level 1 Message Expert Comment by:mills-reeve2012-05-19 I had a very similar issue with the following error (event log): Description: The SQL Server (MSSQLSERVER) service Then try to start the service. Operating system error = 5(error not found). ------------------------------------------------------------ In this case the ERRORLOG file had been marked as read only. Operating system error = %s. news
I ran the command sqlservr.exe /c I get the following error: 2011-11-07 09:52:14.49 Server Error: 17058, Severity: 16, State: 1. 2011-11-07 09:52:14.49 Server initerrlog: Could not open error log file 'E:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'. I re-entered the password used by the identity and it no longer stops. you must try access the log with the user is running sql server.... After I gave the service user full access to the log-directory, I could start the sql-service again.Many greetings from Germany,ThorstenReplyDeleteAdd commentLoad more... http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e
Why cast an A-lister for Groot? Anyone have any ideas of where to go from here? But still I can't start My SQL Server and SQL Server AgenWhen I check the event log, they said "The SQL Server (MSSQLSERVER) service terminated with service specific error 17058(0x42A2). share|improve this answer answered Dec 23 '13 at 13:13 Kuba Miazek 815 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google
For changing SQL Server names: http://msdn.microsoft.com/en-us/library/ms143799.aspx http://sharepoint.nauplius.net Edited by Trevor SewardMicrosoft contingent staff, Moderator Monday, November 07, 2011 5:19 PM Monday, November 07, 2011 5:18 PM Reply | Quote Moderator 0 Here's what I did to fix my problem. Make sure SQL Server service account has the access or atleast make service account to member of local admin group... The Sql Server Service Terminated With Service-specific Error 7024 help.
Application-System-Log-reg.txt Application-System-Log-Cannot-Op.txt 0 Message Active 1 day ago Author Comment by:GabicusC2008-12-03 MohammedU, I got it to work. Tuesday, June 28, 2011 2:20 AM Reply | Quote 0 Sign in to vote Thank you! 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. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f1c8936c-8dab-47fd-9d55-aa8d1939f7a5/help-pls-the-sql-server-mssqlserver-service-terminated-with-servicespecific-error-17058?forum=sqlsecurity I also updated the SQL Client Alias running cliconfg.exe and changed the name from the oldname to the new name.
Reply ignatandrei All-Star 119057 Points 27480 Posts ModeratorMVP Re: Why I can't start the SQL Server and SQL Server Agent Feb 21, 2013 10:39 PM|ignatandrei|LINK 1.please try to search after. 17058 Windows Could Not Start The Sql Server On Local Computer Error Code 3417 Thanks. You cannot post IFCode. You may download attachments.
Thanks, Gabicus SQL-Server-service-Startup-error.bmp sqlservr.exe-error.bmp System-Event-Error.txt 0 Question by:GabicusC Facebook Twitter LinkedIn Google LVL 15 Best Solution byMohammedU Is that registry error source is SQL server? I moved the MSSQL\LOG-directory to onother drive and forget to configure the security settings for the SQL-service user. You may also need to update any alternate access mappings referring to sldevmsp01. The thing is, the installation has been completed and working for over a year. Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer
After I cleared the read only attribute from MSSQL\LOG\ERRORLOG the service started successfully. Operating system error = 3(failed to retrieve text for this error. After the server was exactly the way we wanted it, we created a template of the original server and then provisioned a new virtual server from the template with a different More about the author Privacy statement © 2016 Microsoft.
HTHRegards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com Proposed as answer by Peja Tao Wednesday, June 22, 2011 8:23 AM Marked as answer by Peja Tao Monday, July 11, 2011 1:11 AM Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer Error 1067 I would like you to make sure that SQL Server service account has permissions to read and write on the folder for ERRORLOG. All-Star 21620 Points 2496 Posts Re: Why I can't start the SQL Server and SQL Server Agent Feb 25, 2013 05:01 AM|Chen Yu - MSFT|LINK Hi, From your error message, you
and make sure SQL server service account has the permissions to the folder if the folder exists and nothing got changed... 0 Message Active 1 day ago Author Comment by:GabicusC2008-12-03 You cannot post events. The account that I use on this is the same account that I have used for the past year. Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer Error 1069 MS SQL Server Advertise Here 764 members asked questions and received personalized solutions in the past 7 days.
Solved SQL Service will not start. The SQL Server service should have written another error (either into th event log or the errorlog) that contains the internal error that happened. We had a major windows update pack applied on Saturday. 100's of patches that had not been applied for a few months. http://linuxprofilm.com/sql-server/the-sql-server-mssqlserver-service-terminated-with-service-specific-error-17058.html Join & Ask a Question Need Help in Real-Time?
You cannot delete your own posts. share|improve this answer answered Dec 23 '13 at 11:27 TomTom 1 yes it is a permission error. By the time I got more space added to my E:drive and restarted the machine, I keep getting this error: The SQL Server (MSSQLSERVER) service terminated with service-specific error 17058 (0x42A2). Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the
I did an "attach database" of a copy of a database from our MOSS 2007 environment. Here's what I did to fix my problem. Here are the full Event Properties.