10-17-2009 07:49 AM
Solved! Go to Solution.
10-22-2009 08:51 AM
First of all, Microsoft has clarified its support policy, and SQL Express 2005 is supported in our virtual environment on a Windows Server 2008 SP2 x64 guest and VMware vSphere host. Microsoft has a helpful reference as to exactly which virtualized environments they will support. See the Server Virtualization Validation Program wizard at http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvpwizard.htm.
In this case Microsoft made the following recommendation, which did successfully resolve the issue. To summarize the problem, the security update KB970892 failed to install because the original installation of SQL Express 2005 SP3 did not run to a final completion, even though there was no indication of any problem during the original installation process.
The fix is as follows:
I'll be interested to hear how this works for others.
10-17-2009 10:43 PM
10-18-2009 12:41 AM
10-18-2009 01:18 PM
10-19-2009 01:26 AM
Did someone try this: http://support.microsoft.com/kb/971818
Repair the SQL Server 2005 instance by using Add or Remove Programs in Control Panel. To do this, follow these steps:
Thanks for help and regards.
F.
10-19-2009 08:23 AM
10-19-2009 03:48 PM
10-19-2009 05:54 PM
10-19-2009 08:19 PM
10-20-2009 04:30 AM
10-20-2009 10:02 AM
Running the same configuration as cpegel :(
Richard
10-20-2009 11:37 AM
10-21-2009 09:41 AM
10-21-2009 12:19 PM
Here is the link that helped me with my password prompt issue.
http://davehope.co.uk/Blog/kb970892-fails-to-install/
10-21-2009 12:19 PM
10-22-2009 08:51 AM
First of all, Microsoft has clarified its support policy, and SQL Express 2005 is supported in our virtual environment on a Windows Server 2008 SP2 x64 guest and VMware vSphere host. Microsoft has a helpful reference as to exactly which virtualized environments they will support. See the Server Virtualization Validation Program wizard at http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvpwizard.htm.
In this case Microsoft made the following recommendation, which did successfully resolve the issue. To summarize the problem, the security update KB970892 failed to install because the original installation of SQL Express 2005 SP3 did not run to a final completion, even though there was no indication of any problem during the original installation process.
The fix is as follows:
I'll be interested to hear how this works for others.
10-23-2009 04:44 AM
...seems to work...
10-24-2009 04:30 AM
10-24-2009 04:39 AM
Microsoft SQL Server 2005 9.00.4035.00
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Time : Sat Oct 24 06:34:12 2009
Machine : SERVER2
Product : SQL Server Database Services
Error : The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
--------------------------------------------------------------------------------
Machine : SERVER2
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.3.4035.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0009_CNSPPCDC2_SQL.log
Last Action : SetInstanceProperty
Error String : The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
Error Number : 29528
--------------------------------------------------------------------------------
10-24-2009 12:13 PM