Thursday, August 17, 2006 12:41 PM
I dont know whether i am at right place or not (please excuse me, if so)
I am using SQL-Server 2005.
My SQL Server (SQLEXPRESS) service does not start automatic (although it’s been set as automatic).
The thing is, if I try to start it manually it throws an error as
“Windows could not start the SQ Server (SQLEXPRESS) 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 17058.”
I too check the Event Log it show as
“The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp “
But this link does not exist.
Thing i notice is that, this start happen when i install the SharePoint Services with Microsoft SQL Server Desktop Engine (Windows) (WMSDE) & uninstall.
After this i am not able to start that service successfully.
Please help me
Gurpreet S Gill.
Thursday, August 17, 2006 1:23 PMModeratorMSDE normally upgrades to SQL Server if it is installed. In your case, it is the other way around. I would recommend you uninstall SQL Server 2005 Express, uninstall Sharepoint, reinstall Sharepoint back, then reinstall SQL Server 2005 Express back.
Friday, August 18, 2006 4:55 AM
but can you or any body else suggest me the other way out of the problem(except uninstalling).
Gurpreet S. Gill
Thursday, November 09, 2006 10:41 AM
i have Microsoft Windows Update service 2.0 installed, i downloaded new version MWUS 3.0 beta when i installing i got some error for that installation is terminated, I restarted my installation then SQL server 2005 Embedded edition service is stopped, when i starting every time i am getting this error:
The SQL Server 2005 Embedded Edition (MICROSOFT##SSEE) service terminated with service-specific error 17058 (0x42A2).
Please any one suggest me what I have to do?
Tuesday, June 12, 2007 4:40 PMHi there,
I had the same problem, and I solved it by changing that the service should start by the local system admin from its properties. hope that helps.
Wednesday, April 30, 2008 5:09 AMthx,it's ok!
Wednesday, May 07, 2008 5:12 PMI found that this error code (got on SQL Server 2005 Developer Edition) was due to the access rights of the account used to run the SQL Server Service. The shotgun-approach fix is to make that account a member of the local machine's Administrators group.
Friday, September 05, 2008 1:13 AM
thats another fix that i found
first open sql server configuration manager then select services
find sql server (mssqlserver or sqlexprees who is the failure) right click -> properties
select the advanced tab from the services properties window and be sure the startup parameters
for ex: there is a 2005 developer edition
-dC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
***you find your path same tab(advanced tab) named Data Path
Saturday, June 27, 2009 11:53 PMHi All,
recently I had the same issue.. The SQL Server (MSSQLServer) service terminated with service-specific error 17058 (0x42A2).
I have fixed the issue by providing full control for the SQL services account on (Network service account in my case) errorlog physical path "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG" and to the Tempdb physical path.
hope this will resolve the issue.
Friday, October 02, 2009 4:53 PM
I have run into the same problem - and apparently some others. Visual Studio 2008 requires SQLEXPRESS for interaction with the App_Data folder in Web Projects. I downloaded SQLEXPR32_x86_ENU.exe Version 10.0.1600.22 to my local system to install a named instance of SQLEXPRESS on my local machine. One day and five installs/uninstalls later I am beginning to wonder. I have used both NT AUTHORITY and Local System as Service account without success. I still have about 3G left on this hard drive but with each iteration, it is getting smaller. At one time I was able to start the service but it would 'spontaneously' stop.
A collection of errors reported on different installation attempts is as follows:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058
Wait on the Database Engine recovery handle failed.
Error: 15209, Severity: 16, State: 1 An error occurred during encryption.
The SQL Server (SQLEXPRESS2008) service terminated with service-specific error 2148081668 (0x80092004).
I am sure I am either using the wrong cab file or am doing something so wrong I can't see it. Is there some location that will give stepwise instructions - other than the installation program - that will improve my chances of being able to sucessfully load SQLEXPRESS?
Monday, October 05, 2009 5:40 PM
Wednesday, December 23, 2009 5:44 AMHi Gurpeet,
The service account used to run the SQL Service should have Local Admin permission. Please add the service account to the local system Administrator group
Friday, May 14, 2010 5:12 AM
How do you "add the service account to the local system Administrator group?"