Error Code 17058 Mssqlserver
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more sql server error 17058 about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask
Error 17058 Sql Server 2008
Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn error 17058 sql server service from others in the community. 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 top Windows could
The Sql Server (mssqlserver) Service Terminated With Service-specific Error 17058
not start the SQL Server (mssqlserver) service on local computer error 17058 up vote 3 down vote favorite 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: Can anyone help me? Thanks. Edit: The OS of virtual machine is windows server 2008. sql-server sql share|improve this question edited Dec 23 error 17058 severity 16 state 1 '13 at 9:57 asked Dec 23 '13 at 9:08 bdkhsn 18114 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 | show 2 more comments 2 Answers 2 active oldest votes up vote 2 down vote accepted CHeck for another error in
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Error 17058 Unable to start a service account on MSSQLServer and SQL Agent SQL Server > SQL Server Security Question 0
Error 17058 Sql Server 2005
Sign in to vote hi I am intalling SQL 2008 standard with SP1 on a
Initerrlog Could Not Open Error Log File ''. Operating System Error = 3
Windows Server 2003 R2 SP2. I installed as "local service account" for MSSQLServer (SQL database engine) and SQL agent. But I windows could not start the sql server (mssqlserver) service on local computer want to change to "service account" as [domain\svc_XXX] for MSSQLserver and SQL agent. I add the [domain\svc_XXX] in local security policy - "Log as a service" and also add in SSMS - Security - New Login http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e (windows authentication. When I started the MSSQLserver and SQL agent using the [domain\svc_XXX], I got an error 17058. Initerrlog: could not open error log file." Operating system error=3 (The system cannot find the path specified). I don't know where else to look at.. Also, how do I find the cumulative service pack for SQL server 2008 standard? thanks Irene Tuesday, August 17, 2010 9:13 PM Reply | Quote All replies 0 Sign https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0bf836db-84f8-41d9-9890-68a3eb49f1f5/error-17058-unable-to-start-a-service-account-on-mssqlserver-and-sql-agent?forum=sqlsecurity in to vote When changing the Service account where did you change it? If you used the Windows Service console, you made an error. In SQL Server when changing service accounts (from 2005+) you HAVE to use SQL Server Configuration Manager, because there are permissions that are missed. Like indicated by your errors, give that a try. Tuesday, August 17, 2010 10:03 PM Reply | Quote 0 Sign in to vote Going by the error message, it states that the service account does not have access to the SQL Server folders. Please check the permissions and as suggested by Mohit use Configuration Manager to make the changes to Service Account Pradeep Adiga My blog: http://www.sqldbadiaries.com Wednesday, August 18, 2010 5:21 AM Reply | Quote 1 Sign in to vote Pradeep is right. SQL Service account doesnt have necessary permission in folders and registry keys. I hope you have provided permission only in SQL and not in windows. Since you are in SQL2K8 you have default groups in windows, just add the service account to these SQL default groups and then give a try. Make sure you change the service account through SQL Server Configuration manager.Vidhya Sagar. Mark as Answer if it helps! Wednesday, August 18, 2010 6:45 AM Reply | Quote Moderator 0 Sign in
SERVER - Event 17058 - initerrlog: Could not Open Error Log File August 5, 2016Pinal DaveSQL1 commentIf you have ever interacted with me or taken my services, you http://blog.sqlauthority.com/2016/08/05/sql-server-event-17058-initerrlog-not-open-error-log-file/ would notice that I always ask for ERRORLOG in almost all http://stackoverflow.com/questions/17273021/windows-could-not-start-the-sql-server-mssqlserver-on-local-computer-error of my contact with my client. Once of my friend contacted me and when I asked for ERRORLOG, he informed that there is no ERRORLOG file and SQL is not getting started. I suggested him that we should analyze event log for further sql server details, after interestingly, we found the following details in the event 17058 about initerrlog: Could not Open Error Log File.Log Name: Application Source: MSSQLSERVER Event ID: 17058 Task Category: Server Level: Error Description: initerrlog: Could not open error log file ". Operating system error = 3(The system cannot find the path specified.). We finally error 17058 sql found that the error occurs due to the insufficient privilege of SQL Server Service Account in the Log directory: E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LogHere is the fix of the issue.Start SQL Server Configuration manager.Click to select ‘SQL Server Services' from the left menu options.On the right panel, right click on ‘SQL Server (MSSQLSERVER)' and click ‘Properties'. You may want to choose correct service.Click ‘Startup Parameters' tab. Note the location after -e parameter.Browse the Log location " E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER \MSSQL\Log".Right click on the folder "Log" and click Properties and then to visit to "Security" tab. Now, check SQL Server service account permission on this folder and give proper access to this folder.Now, Restart the SQL Server service. If you face the same error again, try to change highly privileged service account like "Local System".After giving permission, we were able to start the SQL Service. Have you faced a similar error?Reference: Pinal Dave (http://blog.sqlauthority.com) Tags: SQL Error Messages, SQL
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Windows could not start the SQL Server (MSSQLSERVER) on Local Computer… (error code 3417) up vote 4 down vote favorite 2 For some reasons I moved this folder : (Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL) to another drive, then returned it to the same location, but sql server has stopped working, showing this error when trying to start it again: "Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417." I tried many solutions discussed in different forums, but none of them work for me. The folder is not compressed or encrypted. My sql server version is 2012: Microsoft SQL Server Management Studio 11.0.3128.0 Microsoft Analysis Services Client Tools 11.0.3128.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.18047 Operating System 6.1.7601 Thanks for your kind help in advance. sql-server share|improve this question asked Jun 24 '13 at 10:15 Kardo 3242622 1 Check that the account running the sql server service has access rights to the folder. –jpw Jun 24 '13 at 10:39 @jpw, The is fixed :) Thanks a lot for your short and perfect answer :) –Kardo Jun 24 '13 at 10:52 I ran into this problem after changing IPAll to use a specific port. Couldn't bring the server back online until the setting was changed back to Dynamic Ports. –Tim Jun 13 '15 at 12:05 add a comment| 8 Answers 8 active oldest votes up vote 6 down vote Check if you did compress the driver or folder in