Cannot Start Sql Server Error 17058
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 error 17058 sql server 2008 Us Learn more about Stack Overflow the company Business Learn more about hiring error 17058 sql server 2005 developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange sql server error code 17058 is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's
Error 17058 Sql Server Service
how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Windows could 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 the sql server (mssqlserver) service terminated with service-specific error 17058 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 '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
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error 17058 starting SQL Server (MSSQLSRVER) service on SharePoint Server windows could not start the sql server on local computer error code 3417 SharePoint > SharePoint 2010 - Setup, Upgrade, Administration and Operations Question 0
Error 17058 Severity 16 State 1
Sign in to vote We are in the process of upgrading from MOSS 2007 to SharePoint 2010. I
Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer
created a SharePoint 2010 development server. All elements of the SharePoint environment are contained on this one server. This has MSSQL Enterprise installed on it as well as SharePoint http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e 2010. I did an "attach database" of a copy of a database from our MOSS 2007 environment. Everything was looking good. This server was to be a template for a series of developer SharePoint environment in an ESX VMWare environment. After the server was exactly the way we wanted it, we created a template of the original server and then https://social.technet.microsoft.com/Forums/office/en-US/6df7d5a2-3d7a-4aa2-bc48-8ae68d9562f6/error-17058-starting-sql-server-mssqlsrver-service-on-sharepoint-server?forum=sharepointadminprevious provisioned a new virtual server from the template with a different server name. Obviously nothing worked. I ran STSADM -o renameserver and it completed fine. One thing that happens now is that the SQL Server (MSSQLSERVER) service will not start. Here is the error message in the event log: The SQL Server (MSSQLSERVER) service terminated with service-specific error %%17058. At the command prompt I went to c:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\binn. 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'. Operating system error = 5(Access is denied.). The account that I am using is a local administrator account. Anyone have any ideas of where to go from here? We really want to create these individual SharePoint environments for our developers in preparation for our upgrade to SharePoint 2010. They need to rewrite some of our custom web parts. Thanks for anyone that has an idea. Monday, November 07, 2011 5:02 PM Reply | Quote Answ
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/17273021/windows-could-not-start-the-sql-server-mssqlserver-on-local-computer-error workings and policies of this site About Us Learn more about Stack http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150023 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; sql server 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 error 17058 sql 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 af
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) sql server 2008 express wont start Reply to Topic Printer Friendly Author Topic naushi44 Starting Member USA 12 Posts Posted-09/12/2010: 22:43:33 I installed a sql server 2008 express and it worked fine the first time. Now I am trying to start it and I get this message. 'the request failed or service did not respond in a timely fashion. consult the event log'. what am I doing wrong. I have all the protocol enabled. it is on my personal PC.any help will br appreciatednaushi hussain sks198117 Starting Member India 46 Posts Posted-09/13/2010: 08:52:28 Can you please post the error message from event log? naushi44 Starting Member USA 12 Posts Posted-09/13/2010: 11:04:45 application erroriniterrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).system error The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).naushi hussain sks198117 Starting Member India 46 Posts Posted-09/13/2010: 11:26:01 Can you please try once changing service account to local system account?Hope this should work for you..Below are the link where u can find more optionshttp://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/6b5b82e5-1346-4d59-86b0-7eaac7b930a7 shankbond Starting Member India 5 Posts Posted-04/11/2013: 05:32:17 thanks it really helped Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availabilit