1. Extracted SQL Server 2005 Express Service Pack 1 files to local filesystem.
2. Ran setup.exe from local filesystem.
3. Changed all installation paths to D. Specified data files go to D:\Data
3. Set all services to run as Local System.
4. Did not reboot.
5. Extracted SQL Server 2005 Express Service Pack 2 files to local filesystem.
6. Attempted an unattended installation using /settings and a modified template.ini file.
7. Checked C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt which did not show any errors.
8. SELECT @@VERSION showed the version number is 9.00.2470.00, which indicates the upgrade was not actually successful.
This is what was in the modified template.ini file:
INSTANCENAME=MSSQLSERVER
INSTALLSQLDIR="D:\Program Files\Microsoft SQL Server\"
UPGRADE=SQL_Engine
INSTALLSQLSHAREDDIR="D:\Program Files\Microsoft SQL Server\"
ENABLERANU=0
Tried added this, which did not help:
REINSTALLMODE=vomus
Also tried adding this, which did not help, either:
INSTALLSQLDATADIR="D:\Data\"