Re: Can't start sql2005 service anymore



I can think of one reason that could cause this. When SQL server process is
killed or stated from console as different account then service it leaves
named pipe opened and subsequent startup fails with this error. A possible
solution is to reboot the machine.

--
-Milos Cimfl
This posting is provided "AS IS" with no warranties, and confers no rights.


"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:uMbOakp1GHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
I checked it says:
Starting up database 'model'.
2006-09-11 13:24:15.15 Server Error: 17182, Severity: 16, State: 1.
2006-09-11 13:24:15.15 Server TDSSNIClient initialization failed with
error 0xd, status code 0x4.
2006-09-11 13:24:15.15 Server Error: 17182, Severity: 16, State: 1.
2006-09-11 13:24:15.15 Server TDSSNIClient initialization failed with
error 0xd, status code 0x1.
2006-09-11 13:24:15.15 Server Error: 17826, Severity: 18, State: 3.
2006-09-11 13:24:15.15 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.
2006-09-11 13:24:15.15 Server Error: 17120, Severity: 16, State: 1.
2006-09-11 13:24:15.15 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.



"Milos Cimfl [MSFT]" <mcimfl@xxxxxxxxxxxxx> wrote in message
news:%23I2LE5n1GHA.4924@xxxxxxxxxxxxxxxxxxxxxxx
Can you check if the service, when it starts, creates ERRORLOG file. It
should be somewhere in Program Files\Microsoft SQL
Server\MSSQLSERVER\LOG.

--
-Milos Cimfl
This posting is provided "AS IS" with no warranties, and confers no
rights.


"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:%23depaXc1GHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
It tells me it's internal windowss error or internal serive error



"Milos Cimfl [MSFT]" <mcimfl@xxxxxxxxxxxxx> wrote in message
news:uKzCNIc1GHA.1292@xxxxxxxxxxxxxxxxxxxxxxx
Do you know if the upgrade succeeded? You should check if SQL Server
creates errorlog files when it tries to start.

--
-Milos Cimfl
This posting is provided "AS IS" with no warranties, and confers no
rights.


"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:Or8x0hb1GHA.480@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
After I upgraded sql2k to sql2005. I can't start the server service
anymore.
Any ideas?

Thanks











.



Relevant Pages

  • Re: Connection Problems
    ... >Program Manager ... >> Repository to SQL Server 2000. ... >> confers no rights. ...
    (microsoft.public.sqlserver.olap)
  • Re: critical section in tsql
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Use of included script samples are subject to the terms specified at ... > lockbut would feel safer if i could do it in the sql server 2000. ...
    (microsoft.public.sqlserver.xml)
  • Re: DMO & SQL 2005
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > So it will use the same objects/syntax as those for SQL2000 then? ... there will be SQLDMO 9 shipping in SQL Server 2005. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant start sql2005 service anymore
    ... Check the SQL Server error log and the Windows event logs for information ... This posting is provided "AS IS" with no warranties, and confers no ... rights. ...
    (microsoft.public.sqlserver.setup)
  • Re: Server 2003 Service Pack 2 extracts and fails to install
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... I dont see an error log being created. ...
    (microsoft.public.windows.server.setup)