"KMook" wrote:

> When trying to upgrade msde 2000 sp3a named instance to sp4 with the
> following parameters,
>
> "setup /upgradesp sqlrun /i c:\msdesp4\wti.msi /settings
> c:\msdesp4\setup.ini UPGRADEPWD=???? (actual admin password) /L*v
> c:\msdesp4\msdelog.log"
>
> where the setup.ini file contains,
> SECURITYMODE=SQL, UPGRADEUSER=SYSADM, INSTANCENAME=DBSERVER,
>
> the upgrade itself appears to run to completion, but then it generates an
> error "Unable to run the script files". When I look at the .log and
> sp1_serv_uni.out, it says the server is running in single user mode and so
> another administrator can not connect. From what I can see the server was not
> told to start up in single user mode. The upgrade itself appears to have
> worked. When I connect and select @@version, it is reporting 2026, but I'm
> quite sure my customers are not going to be pleased with the error message.
> The server is on the local machine, as is the upgrade install.
>
> Is there anything I can do programmatically to fix this? Thank you for any
> help you can give me.
>