Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Express instance out of date, cannot be upgraded.

New Member
Posts: 3
Country: USA

SQL Express instance out of date, cannot be upgraded.

[ Edited ]

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?

 

Note that I've already tried this solution from Microsoft to work around ACT's broken install, and this one from Sage.

 

Any suggestions?

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: SQL Express instance out of date, cannot be upgraded.

So what happens when you follow Sage's documentation?

New Member
Posts: 3
Country: USA

Re: SQL Express instance out of date, cannot be upgraded.

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". 

New Member
Posts: 3
Country: USA

Re: SQL Express instance out of date, cannot be upgraded.

[ Edited ]

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.