09-08-2011 10:53 AM - edited 09-08-2011 01:54 PM
We are using ACT 2009, hosted on a Windows Server 2008 machine. The SQL Express 2005 instance that ACT installed itself with is out of date and has security issues, but Windows Update is unable to correct the problem because ACT has restricted access to the database.
How can we fix this so that the security updates can be applied to the ACT database server?
09-08-2011 01:50 PM
That probably would have been important information to include, yeah.
When I run Sage's updater app:
It unzips and attempts to create the sqlexpr.exe file, which appears to start SQL Server Setup. SQL Server Setup then crashes. the application then restarts the SQL serveice, reports that it has completed successfully, and displays the log file.
The log file includes the error: "The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation."
Attempting a manual update using the SQL Express Installer gets to the same point ("setting internal properties") before failing with the an "unspecified error".
09-08-2011 01:53 PM - edited 09-08-2011 01:54 PM
Oh, and: This KB article suggests a registry change to allow Windows Update to update the SQL server install. However, the value they suggest changing to 0 is already a 0.