Error Code 17058
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server sql server 2005 error 17058 2008 » SQL Server 2008 - General » Error 17058 when trying the sql server (mssqlserver) service terminated with service-specific error 17058 to start MSSQLSERVER... 12 posts,Page 1 of 212»» Error 17058 when trying to start MSSQLSERVER service Rate Topic error code 17058 sql 2008 Display Mode Topic Options Author Message luissantosluissantos Posted Monday, August 2, 2010 12:31 PM Old Hand Group: General Forum Members Last Login: Tuesday, March 29, 2016 4:53 AM Points: 319,
Error 17058 Severity 16 State 1
Visits: 747 Hello comunityAfter running the setup of sql server 2008 on my HP server with OS Windows server 2008 R2 standard 64 bits,the setup return errors failed on theses services:-Database engine services-Sql Server Replication-Full text search-Reporting ServicesWhen i try to start MSSQLSERVER, i receive the following error :event ID 17058initerrlog: Could not open error log file ''. Operating system error corporations code 17058 = 3(failed to retrieve text for this error. Reason: 15105).Curiously, the installation on : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\have only create theses folders : binn, install and upgradeand also these files:-sql_engine_core_inst_keyfile.dll-sql_fulltext_keyfile.dllCould someone give me some help , because is the first time that i have this problem and i don´t know how to solve them.Many thanks and best regardsLuis Santos Post #962384 luissantosluissantos Posted Tuesday, August 3, 2010 7:14 AM Old Hand Group: General Forum Members Last Login: Tuesday, March 29, 2016 4:53 AM Points: 319, Visits: 747 Hello comunityI solve this problem and for those person that have the same one would should install sql server 2008 not by the autorun option, but you must with right click select : Open and Run setup as administrator.Also, if you open SSMS and you try to browse server name and nothing appears, you need just to writethe correct server name or instance\servername.I hope this conclusion help other users with this kind of situation.Best regards.Luis Santos Post #962771 julian.hatwelljulian.hatwell Posted Monday, August 8, 2011 10:32 AM Grasshopper Group: General Forum Members Last Login:
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 initerrlog could not open error log file ''. operating system error = 3 SQL Server > SQL Server Security Question 0 Sign in to vote hi
The Sql Server Service Terminated With Service-specific Error 7024
I am intalling SQL 2008 standard with SP1 on a Windows Server 2003 R2 SP2. I installed as "local
Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer
service account" for MSSQLServer (SQL database engine) and SQL agent. But I want to change to "service account" as [domain\svc_XXX] for MSSQLserver and SQL agent. I add the [domain\svc_XXX] in local security http://www.sqlservercentral.com/Forums/Topic962384-391-1.aspx policy - "Log as a service" and also add in SSMS - Security - New Login (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 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 the cumulative service pack for SQL server 2008 standard? thanks Irene Tuesday, August 17, 2010 9:13 PM Reply | Quote All replies 0 Sign 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 def
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 would notice that I always ask for ERRORLOG in almost all of my contact with my client. Once of my friend http://blog.sqlauthority.com/2016/08/05/sql-server-event-17058-initerrlog-not-open-error-log-file/ 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 details, after interestingly, we http://forums.asp.net/t/1884585.aspx?Why+I+can+t+start+the+SQL+Server+and+SQL+Server+Agent 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 sql server ". Operating system error = 3(The system cannot find the path specified.). We finally 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 the sql server 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 Server, SQL Server Management Studio, Starting SQL416Related Articles SQL SERVER - 2005 - SSMS Change T-SQL Batch Separator May 18, 2007Pinal Dave SQL SERVER - FIX - The term ‘Invoke-Sqlcmd' is not recognized as the name of a cmdlet November 23, 2014Pinal Dave SQL SERVER - FIX - Error: Alter failed for Server ‘Server Name' in Check Integrity task September 2, 2015Pinal Dave 1 comment. Leave new Jeff Bennett August 6, 2016 8:36 pmPinal, I have seen similar errors, although the actual error number may be different, when the server event log is full and the SQL agent cannot write to that log. If that happens, SQL will not start.ReplyLeave a Reply Cancel reply Pinal Dave is a technology e
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/Why I can't start the SQL Server and SQL Server Agent Why I can't start the SQL Server and SQL Server Agent [Answered]RSS 3 replies Last post Feb 25, 2013 05:01 AM by Chen Yu - MSFT ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply Junior1012 Member 95 Points 282 Posts Why I can't start the SQL Server and SQL Server Agent Feb 21, 2013 09:54 PM|Junior1012|LINK Hi, I been done TCP/IP protocols Enable and VIA Disable. 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). Please, can anyonegive meany idea or advice on the above error. Thanks in advanced. Reply ignatandrei All-Star 119038 Points 27456 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 sql server. 2. full error , please .NET Teacher | .NET Videos 5 minutes Reply ashkc Member 744 Points 245 Posts Re: Why I can't start the SQL Server and SQL Server Agent Feb 22, 2013 11:20 AM|ashkc|LINK You'll want to set the SQL Server Service to Manual instead of Automatic on both servers. The SQL Server Service is started by the cluster service, not by using the automatic setting on Cluster servers. By setting the services to Manual startup this error message will go away. Reply Chen Yu - MS... 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 could follow below thread's method to solve your problem, it will help you. Please check : http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/th