sql server msde: I am attempting to install MSDE 2000 SP4. Here is my invocation:
setup DATADIR="D:\" SAPWD="xxxxxx" DISABLENETWORKPROTOCOLS=0

It fails with the following error:
"Setup failed to configure the server."

Here is an excerpt from the setup log:
<...>
MSI (s) (E4:30) [21:30:18:500]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI68.tmp, Entrypoint:
InstallSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity succeeded
MSI (s) (E4:84) [21:30:18:671]: Executing op: ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (E4:84) [21:30:18:671]: Executing op:
CustomActionSchedule(Action=SkuIt.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=SkuIt,)
MSI (s) (E4:30) [21:30:18:687]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI69.tmp, Entrypoint: SkuIt
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
MSI (s) (E4:84) [21:30:18:921]: Executing op: ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (E4:84) [21:30:18:921]: Executing op: CustomActionSchedule(Action=ConfigServer.2D02443E_7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (E4:58) [21:30:18:937]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI6A.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1\Gavin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (c) (64:74) [21:32:40:390]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
MSI (s) (E4!04) [21:35:07:531]: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the
server error logs and setup error logs for more information.
Action ended 21:35:07: InstallFinalize. Return value 3.
<...>

hi Gavin,
[quoted text, click to view]

this exception is usually related to un-clenade pvrevious installations
removal, as indicated in
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql ,
so you have to clean up you registry and file system... I do usually use
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991 method, but
please be warned that one will not clear Windows Installer related registry
entry, that require use of MSIZap.exe, part of the Windows Installer
Platform SDK...

another issue that has become relevant is becouse of failure and/or
corruption of MDAC 2.8 stack on WinXP platform.. for XP sp2 there's actually
no refresh for MDAC 2.8 sp2, but you can check
http://www.macropool.com/en/download/mdac_xp_sp2.html for instructions on
how to fix that..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

[quoted text, click to view]

There seems to be anumber of causes for this. Are you installing it on a
remote server? If so - are youconnected as Administrator or another admin
account?

Reason I ask is that I had the exact same problem earlier today and Googling
suggested that trying to install it on a remote server over Remote Desktop
can cause problems with permissions. I was actually installing it on a
remote server using PCAnywhere using an account that has Admin privileges
but it kept failing. In a moment of 'divine inspiration' I logged directly
into the Administrator account and it installed with no problem.

The good news and bad news is that you were right!
I don't know whether to sing/spit/rejoice/cry/etc.

The whole time, I was working via Remote Desktop. After I read your message, I hooked up a monitor, keyboard, mouse, and voila!

Thanks Martin!

Is there a prize for reporting a bug to the KB? If so, surely you qualify.

Jake


[quoted text, click to view]

hi Jake,
[quoted text, click to view]

actually it's a known issue.. I just assumed it was related to the "general
related issues", but, voila..
http://search.support.microsoft.com/search/default.aspx?spid=global&query=msde+AND+terminal&catalog=LCID%3D1033&pwt=false&title=false&kt=ALL&mdt=0&comm=1&mt=1&ast=1&ast=2&ast=3&mode=a&x=17&y=12
:D
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply