Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Situation
SQL will not install
ERROR: SQL Server setup could not validate the service accounts
Resolution
1) As always, you first need to run desktop\extprod\dotnetfx.exe, if the .netframework is not already installed.
2) Use this command line to install SQLExpress:
.\Desktop\ExtProd\\MSDE2005\\sqlexpr.exe INSTANCENAME=MSSQLSERVER ADDLOCAL=All SAPWD=tscensus DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SQLACCOUNT="NT AUTHORITY\SYSTEM" /noreboot /qb
NOTE:You can also specify INSTALLSQLDIR=... INSTALLSQLDATADIR=... if you do not want to use the default, which is program files\Microsoft SQL Server.
The SQLACCOUNT parameter is the problematic one. It needs to be translated into whatever language you are dealing with. For example, French is "AUTORITE NT\SYSTEM". Then once the SQLExpress install is complete, use the SQL Server Configuration Manager (newly installed with SQL Express) to change the logon to "Local System" (From SQL Server Configuration Manager, open "Sql Server 2005 Services", then open "SQL Server (MSSQLSERVER)" and change log on to "Built In Account - Local System).
The point is, you will have to use a SQLACCOUNT value that will work. Once installed, you can change the local system account if necessary. If you are familiar with the language you are using, you can probably get the right value for the System user into the command line.
Do not change any of the other parameters. It is especially important to leave the SAPWD and INSTANCENAME as shown.
3) Once SQL Express is all set, you can run the ZAM Standalone installation. It will see that you have MSSQLSERVER installed, and skip installing it.