SQL server not starting
-
I get the following errors when starting my local SQL server:
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0xd.2009-08-05 11:46:04.68 spid8s Starting up database 'model'.
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0x1.2009-08-05 11:46:04.69 spid5s Starting up database 'msdb'.
2009-08-05 11:46:04.69 Server Error: 17826, Severity: 18, State: 3.
2009-08-05 11:46:04.69 Server Could not start the network library because o
f an internal error in the network library. To determine the cause, review the e
rrors immediately preceding this one in the error log.2009-08-05 11:46:04.69 Server Error: 17120, Severity: 16, State: 1.
2009-08-05 11:46:04.69 Server SQL Server could not spawn FRunCM thread. Che
ck the SQL Server error log and the Windows event logs for information about pos
sible related problems.I have looked at a few solutions to the errors such as disabling the VIA protocol in the configuration manager, but it was already disabled. I did discover that the issue seems to be with the TCP/IP protocol, which I can't even enable. I found this page: http://www.thelastpickle.com/2008/02/28/invalid-server-tcpip-settings/[^] unfortunately the properties of the TCP/IP protocol are totally missing the “Listen All” property. The only property under TCP/IP is "keep alive". Enabling a single IP doesn't help either. Any recommendations?
-
I get the following errors when starting my local SQL server:
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0xd.2009-08-05 11:46:04.68 spid8s Starting up database 'model'.
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0x1.2009-08-05 11:46:04.69 spid5s Starting up database 'msdb'.
2009-08-05 11:46:04.69 Server Error: 17826, Severity: 18, State: 3.
2009-08-05 11:46:04.69 Server Could not start the network library because o
f an internal error in the network library. To determine the cause, review the e
rrors immediately preceding this one in the error log.2009-08-05 11:46:04.69 Server Error: 17120, Severity: 16, State: 1.
2009-08-05 11:46:04.69 Server SQL Server could not spawn FRunCM thread. Che
ck the SQL Server error log and the Windows event logs for information about pos
sible related problems.I have looked at a few solutions to the errors such as disabling the VIA protocol in the configuration manager, but it was already disabled. I did discover that the issue seems to be with the TCP/IP protocol, which I can't even enable. I found this page: http://www.thelastpickle.com/2008/02/28/invalid-server-tcpip-settings/[^] unfortunately the properties of the TCP/IP protocol are totally missing the “Listen All” property. The only property under TCP/IP is "keep alive". Enabling a single IP doesn't help either. Any recommendations?
If it was working before and isn't working now, I would look to differences. Maybe a windows update or other software installed. Maybe windows update is on automatic and you don't know it. Try rolling any changes back to when things were working. If it never worked, and this is a "fresh" install, go ahead and remove and reinstall. Byron Mann mannb@hostmysite.com byronosity@gmail.com Software Architect hosting.com | hostmysite.com http://www.hostmysite.com/?utm\_source=bb
-
I get the following errors when starting my local SQL server:
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0xd.2009-08-05 11:46:04.68 spid8s Starting up database 'model'.
2009-08-05 11:46:04.68 Server Error: 17182, Severity: 16, State: 1.
2009-08-05 11:46:04.68 Server TDSSNIClient initialization failed with error
0x2, status code 0x1.2009-08-05 11:46:04.69 spid5s Starting up database 'msdb'.
2009-08-05 11:46:04.69 Server Error: 17826, Severity: 18, State: 3.
2009-08-05 11:46:04.69 Server Could not start the network library because o
f an internal error in the network library. To determine the cause, review the e
rrors immediately preceding this one in the error log.2009-08-05 11:46:04.69 Server Error: 17120, Severity: 16, State: 1.
2009-08-05 11:46:04.69 Server SQL Server could not spawn FRunCM thread. Che
ck the SQL Server error log and the Windows event logs for information about pos
sible related problems.I have looked at a few solutions to the errors such as disabling the VIA protocol in the configuration manager, but it was already disabled. I did discover that the issue seems to be with the TCP/IP protocol, which I can't even enable. I found this page: http://www.thelastpickle.com/2008/02/28/invalid-server-tcpip-settings/[^] unfortunately the properties of the TCP/IP protocol are totally missing the “Listen All” property. The only property under TCP/IP is "keep alive". Enabling a single IP doesn't help either. Any recommendations?
I had the same problem today. Found out that the error 0x2 = The specified service does not exist as an installed service. sc query 2 Only thing that I was able to do was to uninstall the database service then reinstall it.