Hi,

One of our applications came bundled with a MSDE 2000 that got installed
along with the application. The default passwords were changed and the person
who knew the passwords left the organization. Upon rebooting the server the
application is not able to connect to the MSDE since the SQLServer service
has not started. As soon as the service is started, it stops. What might be
causing this and what should be the line of action? Since we do not know the
password, is there any way we can connect to this server?

Thanks.

> As soon as the service is started, it stops.

Check the SQL Server errorlog file as well as the eventlog for error messages.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"ronnie" <ronnie@discussions.microsoft.com> wrote in message
news:1A936121-2C34-4C59-B8FD-F07C37D6F8C7@microsoft.com...
> Hi,
>
> One of our applications came bundled with a MSDE 2000 that got installed
> along with the application. The default passwords were changed and the person
> who knew the passwords left the organization. Upon rebooting the server the
> application is not able to connect to the MSDE since the SQLServer service
> has not started. As soon as the service is started, it stops. What might be
> causing this and what should be the line of action? Since we do not know the
> password, is there any way we can connect to this server?
>
> Thanks.

This is the error message in the SQL Server error log

2008-05-15 09:09:17.77 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)

2008-05-15 09:09:17.77 server Copyright (C) 1988-2002 Microsoft
Corporation.
2008-05-15 09:09:17.77 server All rights reserved.
2008-05-15 09:09:17.77 server Server Process ID is 7372.
2008-05-15 09:09:17.77 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WHATSUP\LOG\ERRORLOG'.
2008-05-15 09:09:17.82 server SQL Server is starting at priority class
'normal'(4 CPUs detected).
2008-05-15 09:09:18.08 server SQL Server configured for thread mode
processing.
2008-05-15 09:09:18.08 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2008-05-15 09:09:18.08 spid3 Starting up database 'master'.
2008-05-15 09:09:18.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
2008-05-15 09:09:18.24 spid5 Starting up database 'model'.
2008-05-15 09:09:18.24 spid3 Server name is 'COMPW2K3SERVER01\WHATSUP'.
2008-05-15 09:09:18.24 spid3 Skipping startup of clean database id 4
2008-05-15 09:09:18.24 spid3 Starting up database 'WhatsUp'.
2008-05-15 09:09:18.26 server Encryption requested but no valid
certificate was found. SQL Server terminating.
2008-05-15 09:09:18.26 server Error: 17826, Severity: 18, State: 1
2008-05-15 09:09:18.26 server Could not set up Net-Library 'SSNETLIB'..
2008-05-15 09:09:18.26 server Unable to load any netlibs.
2008-05-15 09:09:18.26 server SQL Server could not spawn FRunCM thread.
2008-05-14 17:04:44.88 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)



"Tibor Karaszi" wrote:

> > As soon as the service is started, it stops.
>
> Check the SQL Server errorlog file as well as the eventlog for error messages.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
> news:1A936121-2C34-4C59-B8FD-F07C37D6F8C7@microsoft.com...
> > Hi,
> >
> > One of our applications came bundled with a MSDE 2000 that got installed
> > along with the application. The default passwords were changed and the person
> > who knew the passwords left the organization. Upon rebooting the server the
> > application is not able to connect to the MSDE since the SQLServer service
> > has not started. As soon as the service is started, it stops. What might be
> > causing this and what should be the line of action? Since we do not know the
> > password, is there any way we can connect to this server?
> >
> > Thanks.
>
>
>

My guess is that somebody configured "Force protocol encryption" in the tool "SQL Server Network
Utility" for that instance in question.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"ronnie" <ronnie@discussions.microsoft.com> wrote in message
news:44F2BBE2-7182-406A-896E-20A363EFCC74@microsoft.com...
> This is the error message in the SQL Server error log
>
> 2008-05-15 09:09:17.77 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> 2008-05-15 09:09:17.77 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2008-05-15 09:09:17.77 server All rights reserved.
> 2008-05-15 09:09:17.77 server Server Process ID is 7372.
> 2008-05-15 09:09:17.77 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WHATSUP\LOG\ERRORLOG'.
> 2008-05-15 09:09:17.82 server SQL Server is starting at priority class
> 'normal'(4 CPUs detected).
> 2008-05-15 09:09:18.08 server SQL Server configured for thread mode
> processing.
> 2008-05-15 09:09:18.08 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2008-05-15 09:09:18.08 spid3 Starting up database 'master'.
> 2008-05-15 09:09:18.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2008-05-15 09:09:18.24 spid5 Starting up database 'model'.
> 2008-05-15 09:09:18.24 spid3 Server name is 'COMPW2K3SERVER01\WHATSUP'.
> 2008-05-15 09:09:18.24 spid3 Skipping startup of clean database id 4
> 2008-05-15 09:09:18.24 spid3 Starting up database 'WhatsUp'.
> 2008-05-15 09:09:18.26 server Encryption requested but no valid
> certificate was found. SQL Server terminating.
> 2008-05-15 09:09:18.26 server Error: 17826, Severity: 18, State: 1
> 2008-05-15 09:09:18.26 server Could not set up Net-Library 'SSNETLIB'..
> 2008-05-15 09:09:18.26 server Unable to load any netlibs.
> 2008-05-15 09:09:18.26 server SQL Server could not spawn FRunCM thread.
> 2008-05-14 17:04:44.88 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>
>
>
> "Tibor Karaszi" wrote:
>
>> > As soon as the service is started, it stops.
>>
>> Check the SQL Server errorlog file as well as the eventlog for error messages.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
>> news:1A936121-2C34-4C59-B8FD-F07C37D6F8C7@microsoft.com...
>> > Hi,
>> >
>> > One of our applications came bundled with a MSDE 2000 that got installed
>> > along with the application. The default passwords were changed and the person
>> > who knew the passwords left the organization. Upon rebooting the server the
>> > application is not able to connect to the MSDE since the SQLServer service
>> > has not started. As soon as the service is started, it stops. What might be
>> > causing this and what should be the line of action? Since we do not know the
>> > password, is there any way we can connect to this server?
>> >
>> > Thanks.
>>
>>
>>

This is a good guess Tibor, I believe this is the problem of OP.

OP: However, I see this "Enterprise Evaluation Edition" text on top of the
error log. Are you aware of this upcoming problem?

--
Ekrem Önsoy



"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in
message news:uRijXhytIHA.4912@TK2MSFTNGP03.phx.gbl...
> My guess is that somebody configured "Force protocol encryption" in the
> tool "SQL Server Network Utility" for that instance in question.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
> news:44F2BBE2-7182-406A-896E-20A363EFCC74@microsoft.com...
>> This is the error message in the SQL Server error log
>>
>> 2008-05-15 09:09:17.77 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>>
>> 2008-05-15 09:09:17.77 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2008-05-15 09:09:17.77 server All rights reserved.
>> 2008-05-15 09:09:17.77 server Server Process ID is 7372.
>> 2008-05-15 09:09:17.77 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WHATSUP\LOG\ERRORLOG'.
>> 2008-05-15 09:09:17.82 server SQL Server is starting at priority class
>> 'normal'(4 CPUs detected).
>> 2008-05-15 09:09:18.08 server SQL Server configured for thread mode
>> processing.
>> 2008-05-15 09:09:18.08 server Using dynamic lock allocation. [500]
>> Lock
>> Blocks, [1000] Lock Owner Blocks.
>> 2008-05-15 09:09:18.08 spid3 Starting up database 'master'.
>> 2008-05-15 09:09:18.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
>> 2008-05-15 09:09:18.24 spid5 Starting up database 'model'.
>> 2008-05-15 09:09:18.24 spid3 Server name is
>> 'COMPW2K3SERVER01\WHATSUP'.
>> 2008-05-15 09:09:18.24 spid3 Skipping startup of clean database id 4
>> 2008-05-15 09:09:18.24 spid3 Starting up database 'WhatsUp'.
>> 2008-05-15 09:09:18.26 server Encryption requested but no valid
>> certificate was found. SQL Server terminating.
>> 2008-05-15 09:09:18.26 server Error: 17826, Severity: 18, State: 1
>> 2008-05-15 09:09:18.26 server Could not set up Net-Library
>> 'SSNETLIB'..
>> 2008-05-15 09:09:18.26 server Unable to load any netlibs.
>> 2008-05-15 09:09:18.26 server SQL Server could not spawn FRunCM
>> thread.
>> 2008-05-14 17:04:44.88 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>>
>>
>>
>> "Tibor Karaszi" wrote:
>>
>>> > As soon as the service is started, it stops.
>>>
>>> Check the SQL Server errorlog file as well as the eventlog for error
>>> messages.
>>>
>>> --
>>> Tibor Karaszi, SQL Server MVP
>>> http://www.karaszi.com/sqlserver/default.asp
>>> http://sqlblog.com/blogs/tibor_karaszi
>>>
>>>
>>> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
>>> news:1A936121-2C34-4C59-B8FD-F07C37D6F8C7@microsoft.com...
>>> > Hi,
>>> >
>>> > One of our applications came bundled with a MSDE 2000 that got
>>> > installed
>>> > along with the application. The default passwords were changed and the
>>> > person
>>> > who knew the passwords left the organization. Upon rebooting the
>>> > server the
>>> > application is not able to connect to the MSDE since the SQLServer
>>> > service
>>> > has not started. As soon as the service is started, it stops. What
>>> > might be
>>> > causing this and what should be the line of action? Since we do not
>>> > know the
>>> > password, is there any way we can connect to this server?
>>> >
>>> > Thanks.
>>>
>>>
>>>
>
>

Aww sorry, that "Evaluation Edition" thing was from another error log file
=)

--
Ekrem Önsoy



"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in
message news:uRijXhytIHA.4912@TK2MSFTNGP03.phx.gbl...
> My guess is that somebody configured "Force protocol encryption" in the
> tool "SQL Server Network Utility" for that instance in question.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
> news:44F2BBE2-7182-406A-896E-20A363EFCC74@microsoft.com...
>> This is the error message in the SQL Server error log
>>
>> 2008-05-15 09:09:17.77 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>>
>> 2008-05-15 09:09:17.77 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2008-05-15 09:09:17.77 server All rights reserved.
>> 2008-05-15 09:09:17.77 server Server Process ID is 7372.
>> 2008-05-15 09:09:17.77 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WHATSUP\LOG\ERRORLOG'.
>> 2008-05-15 09:09:17.82 server SQL Server is starting at priority class
>> 'normal'(4 CPUs detected).
>> 2008-05-15 09:09:18.08 server SQL Server configured for thread mode
>> processing.
>> 2008-05-15 09:09:18.08 server Using dynamic lock allocation. [500]
>> Lock
>> Blocks, [1000] Lock Owner Blocks.
>> 2008-05-15 09:09:18.08 spid3 Starting up database 'master'.
>> 2008-05-15 09:09:18.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
>> 2008-05-15 09:09:18.24 spid5 Starting up database 'model'.
>> 2008-05-15 09:09:18.24 spid3 Server name is
>> 'COMPW2K3SERVER01\WHATSUP'.
>> 2008-05-15 09:09:18.24 spid3 Skipping startup of clean database id 4
>> 2008-05-15 09:09:18.24 spid3 Starting up database 'WhatsUp'.
>> 2008-05-15 09:09:18.26 server Encryption requested but no valid
>> certificate was found. SQL Server terminating.
>> 2008-05-15 09:09:18.26 server Error: 17826, Severity: 18, State: 1
>> 2008-05-15 09:09:18.26 server Could not set up Net-Library
>> 'SSNETLIB'..
>> 2008-05-15 09:09:18.26 server Unable to load any netlibs.
>> 2008-05-15 09:09:18.26 server SQL Server could not spawn FRunCM
>> thread.
>> 2008-05-14 17:04:44.88 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>>
>>
>>
>> "Tibor Karaszi" wrote:
>>
>>> > As soon as the service is started, it stops.
>>>
>>> Check the SQL Server errorlog file as well as the eventlog for error
>>> messages.
>>>
>>> --
>>> Tibor Karaszi, SQL Server MVP
>>> http://www.karaszi.com/sqlserver/default.asp
>>> http://sqlblog.com/blogs/tibor_karaszi
>>>
>>>
>>> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
>>> news:1A936121-2C34-4C59-B8FD-F07C37D6F8C7@microsoft.com...
>>> > Hi,
>>> >
>>> > One of our applications came bundled with a MSDE 2000 that got
>>> > installed
>>> > along with the application. The default passwords were changed and the
>>> > person
>>> > who knew the passwords left the organization. Upon rebooting the
>>> > server the
>>> > application is not able to connect to the MSDE since the SQLServer
>>> > service
>>> > has not started. As soon as the service is started, it stops. What
>>> > might be
>>> > causing this and what should be the line of action? Since we do not
>>> > know the
>>> > password, is there any way we can connect to this server?
>>> >
>>> > Thanks.
>>>
>>>
>>>
>
>