SQL Server is terminating due to 'stop' request



Hi,

Installation of MSDE SP3A fails on XP SP2 with these messages in the log:-

Warning: override, autoexec procedures skipped.
SQL Server is terminating due to 'stop' request from Service Control Manager.

According to Google lots of people seem to be having this problem but there
does not seem to be a solution apart from manually editing the registry.
Presume I need to follow instructions in Knowledge base article 290991.

Question - As I plan to ship MSDE (or SQL Express) to thousands of users
with no IT skills (teachers in UK schools) is there a tool to automate the
cleaning of the registry for a SQL named instance which has not been
installed or uninstalled cleanly?

Am I misunderstanding where MSDE should be used? It looks like it is not
suitable to ship as a generally purpose database to be installed by non IT
experts. Generally it installs OK but occasionally people get this error
message. The latest incident has happened on a brand new non-networked XP Pro
SP2 machine bought to run our software by a teacher with limited IT skills.
She has been using the non-MSDE version of our software for the last 5 years.
I would like to send her a utility to run to sort out the problem but it
looks like I will have to drive 400 miles to sort this out.

PS We provide unlimited free support to purchasers of our product. This has
not been a problem for us until we started using MSDE.

--
Brian

.



Relevant Pages

  • Re: Is it possible that OLEDB connection is not available on a PC?
    ... Hmm, unlikely as it seems given your OS, corrupted MDAC installation? ... If you still have no joy, I suggest you post to a SQL Server group. ... I believe there MSDE has been updated quite ...
    (microsoft.public.inetserver.asp.db)
  • Re: error 1304 - MSDE
    ... MSDE Installation Fails on Systems That Have SQL Server 2000 ...
    (microsoft.public.de.sqlserver)
  • NTWDBLIB.DLL
    ... I recently installed MSDE 2000 Release A on my computer ... as SQL Server and got it running. ... However, since I am using cuteSQL as an SQL client, ... during MSDE Server installation. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2005 - Berechtigung unter Vista
    ... hast Du das SQL Server 2005 SP2 hinterher installiert? ... Das Setup des SP2 fragt Dich am Ende auch, ob Du den aktuellen User unter Vista zum SQL-Admin machen möchtest. ... Bei der Installation auf dem Notebook hat mir das Setup am Ende gesagt das noch bestimmte Berechtigungen gesetzt werden müssen damit der angemeldete User, vorausgesetzt er ist Admin, auch Admin am SQL Server ist. ...
    (microsoft.public.de.sqlserver)
  • question about patching MSDE 2000
    ... I'm trying to patch it using SQL SP2 (the filename of the ... "This installation package could not be opened. ... installation goes well and patches MSDE if I installed it ...
    (microsoft.public.sqlserver.security)

Loading