Error 17058 Sql Server
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 sql server error 3417 developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is sql server error 17 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 how
Sql Server Error Code 17058
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 try
Error 17058 Severity 16 State 1
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 looking for a root
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 error 17058 sql server 2005 on MSSQLServer and SQL Agent SQL Server > SQL Server Security Question
Initerrlog Could Not Open Error Log File ''. Operating System Error = 3
0 Sign in to vote hi I am intalling SQL 2008 standard with SP1 on a Windows Server windows could not start the sql server (mssqlserver) service on local computer 2003 R2 SP2. I installed as "local service account" for MSSQLServer (SQL database engine) and SQL agent. But I want to change to "service account" as [domain\svc_XXX] for MSSQLserver http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e 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 (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 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 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 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 do
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search https://www.experts-exchange.com/questions/23951723/SQL-Service-will-not-start-I-am-getting-an-error-17058.html Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines http://forums.asp.net/t/1884585.aspx?Why+I+can+t+start+the+SQL+Server+and+SQL+Server+Agent Experts Exchange > Questions > SQL Service will not start. I am getting an error 17058. Want to Advertise Here? Solved SQL Service will not start. I am getting an error 17058. Posted on 2008-12-02 MS SQL Server MS SQL Server 2005 1 Verified Solution 6 Comments 21,959 Views Last Modified: 2012-05-19 I have a SQL Server that has been working fine sql server for the past year. But all of a sudden when I rebooted my server I got this error: "The SQL Server (TESSI2005) service terminated with service-specific error 17058 (0x42A2)." Everything that I have read says that SQL is corrupt and I need to reinstall. Is there something else I can do to keep from re-installing my SQL. 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 17058 sql error source is SQL server? Make sure SQL Server service account has the access or atleast make service account to member of local admin group... Any other errors related to SQL? Go to Solution 6 Comments LVL 15 Overall: Level 15 MS SQL Server 12 MS SQL Server 2005 10 Message Expert Comment by:MohammedU2008-12-02 First check the SQL error log going to the log folder and open it in notepad and see if there is any hint... if not then check the application/system log...as per the screen shot it is complaining the about the binaries... Make sure system db folder and binaries and log folder available and it was not renamed.. 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 MohammedU, Thanks for the reply. I checked the error log file and did not see anything that would help. I then checked the application/system log and got this message. UpdateUptimeRegKey: Operating system error 5(Access is denied.) Do I need to go and make a change to the registry? 0 LVL 15 Overall: Level 15 MS SQL Server 12 MS SQL Server 2005 10 Message Accepted Solution by:MohammedU2008-12-03 Is that registry error source is SQL server? Make sure SQL Server service account has the access or atle
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&