Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.
Cannot start Sql Server (SQLEXPRESS) Service
I try to start the Sql Server (SQLEXPRESS) Service but failed. I got the below error:
2010-03-26 10:03:02.43 Server Microsoft SQL Server 2005 - 9.00.3239.00 (Intel X86)
Apr 9 2008 22:56:02
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2010-03-26 10:03:02.43 Server (c) 2005 Microsoft Corporation.
2010-03-26 10:03:02.43 Server All rights reserved.
2010-03-26 10:03:02.43 Server Server process ID is 4040.
2010-03-26 10:03:02.43 Server Authentication mode is MIXED.
2010-03-26 10:03:02.43 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-03-26 10:03:02.43 Server This instance of SQL Server last reported using a process ID of 2008 at 3/26/2010 9:58:40 AM (local) 3/26/2010 1:58:40 AM (UTC). This is an informational message only; no user action is required.
2010-03-26 10:03:02.43 Server Registry startup parameters:
2010-03-26 10:03:02.43 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-26 10:03:02.43 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-26 10:03:02.43 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-26 10:03:02.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-26 10:03:02.45 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-26 10:03:02.95 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-03-26 10:03:02.96 Server Database mirroring has been enabled on this instance of SQL Server.
2010-03-26 10:03:02.96 spid4s Starting up database 'master'.
2010-03-26 10:03:03.18 spid4s SQL Trace ID 1 was started by login "sa".
2010-03-26 10:03:03.20 spid4s Starting up database 'mssqlsystemresource'.
2010-03-26 10:03:03.21 spid4s The resource database build version is 9.00.3239. This is an informational message only. No user action is required.
2010-03-26 10:03:03.39 spid8s Starting up database 'model'.
2010-03-26 10:03:03.39 Server Virtual Interface Architecture protocol is not supported for this particular edition of SQL Server.
2010-03-26 10:03:03.39 spid4s Server name is 'SITIKHADIJAH\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-03-26 10:03:03.39 spid4s Starting up database 'msdb'.
2010-03-26 10:03:03.46 Server Error: 17190, Severity: 16, State: 1.
2010-03-26 10:03:03.46 Server FallBack certificate initialization failed with error code: 1.
2010-03-26 10:03:03.46 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2010-03-26 10:03:03.46 Server Error: 17182, Severity: 16, State: 1.
2010-03-26 10:03:03.46 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2010-03-26 10:03:03.46 Server Error: 17182, Severity: 16, State: 1.
2010-03-26 10:03:03.46 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2010-03-26 10:03:03.46 Server Error: 17826, Severity: 18, State: 3.
2010-03-26 10:03:03.46 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2010-03-26 10:03:03.46 Server Error: 17120, Severity: 16, State: 1.
2010-03-26 10:03:03.46 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
LVL 47
Line #30 effectively says you are now using a self-signed certificate instead of one signed by a CA. Did you change anything related to that, or change IP numbers or DNS name?
>> Could not start the network library because of an internal error in the network library.
Kindly check whether your have enabled Shared Memory in Network Configuration under Protocols.
If VIA protocol is enabled, just disable it and restart SQL Server services to get it fixed.
Kindly check whether your have enabled Shared Memory in Network Configuration under Protocols.
If VIA protocol is enabled, just disable it and restart SQL Server services to get it fixed.
Shared Memory already enabled and VIA protocol is disable. I try to restart the SQL Server services, but still not work.
Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
What this error means?
What this error means?
You can check the account the service is running - on Services, Properties, on Log On tab.
Check that user has rights to log on as a batch job and log on as a service on security.
Check that user has rights to log on as a batch job and log on as a service on security.
If disabling VIA protocol and restart SQL Services didn't helped, then try repairing the instance..
If it doesn't work, then re-installation is the only option available..
If it doesn't work, then re-installation is the only option available..
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
yup, rrjegan17, I re-install the sql, and that the best solution. The error message did not appear anymore :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005
From novice to tech pro — start learning today.
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Outlook 2007 Ad… 147 lessons
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.