Error while installing MSDE: 0x00000643

[KMH]

Hi, i have insatalled Avast! ADNM one one server and ran it for a while on test with no problems so i decided to now install it on the server that is it supposed to be on but i just can't get anywhere it just keeps on telling me the same thing "Error while installing MSDE: 0x00000643" in a pop up window just as it's about to finish the installation of MSDE, i really don't know what to do 

[Vlk]

Some things to check:

- is there enough HDD space on the system partition?
- is some other MS SQL instance already installed on the machine?
- what is the OS of this machine anyway?


Thanks
Vlk

[KMH]

Hi Thanks that was quick! it is a win2k server with 15gb free on the c:\ thats where i am installing it and no there isn't any other sql on it but this is one of three servers and one of the others does have sql on it,
Thanks

[Vlk]

I believe MSDE install generates some kind of a log during install... let me grab someone who knows more about this.

BRB.

[KMH]

Thanks a lot i'll be here

[Vlk]

BTW are you really based in Africa...? I see you're connecting via an ISP in the UK...

[Forejt]

Check the folder "Program Files\Microsoft SQL Server\MSSQL$AVAST\LOG\", it should contain errorlog files, please send all these files to my email.
Also, did you make any changes on SQL Settings page of ADNM setup?

[KMH]

yeah i am right at the bottom of africa and we aren't in south africa either a lot of people seem to think that moz is in sa we aren't - i was told the isp was in the states   oh well

[KMH]

i don't have any SQL Server folders in program files??? and no i just left the page as it came up with the defaults - yesterday i tried to load the msde before i loaded the ADNM but it was giving me an error saying something about a SAPWD?

[KMH]

i have just done a search there is definately no log for this - strange

[Forejt]

Probably they were deleted after MSDE installation failed. So try to install MSDE separately (before installing ADNM). Run MSDE setup with the following command-line:
setup.exe SAPWD=fsg74DM2Mdm INSTANCENAME=avast SECURITYMODE=SQL COLLATION=Latin1_General_CI_AS DISABLENETWORKPROTOCOLS=1 REBOOT=ReallySupress

SAPWD is password for 'sa' account, it should be strong password containing uppercase and lowercase letters and numbers.

If the installation fails again, before confirming the error message, try to check for the errorlog files.

[KMH]

ok i tried that but it just got to the end and rolled back with no error msg or log. strange again

[Vlk]

Would this MS KB article be helpful?
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B829386

[KMH]

ok i'm checking it out now i'll let you know - thanks so much

[Vlk]

If this doesn't help, specifying the verbose log command-line option ( /L*v ) as stated in the article would probably be a good idea in any case...

Thanks