Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 9
in [Windows Update]
|
Prev: problem with MSXML update KB927978 errorcode: 0x659
Next: Microsoft .NET Framework 3.0: x86 (KB928416) Error Code: 0x13EC
From: TonyJ on 31 Mar 2007 11:40 Peter I have the same problem. I checked the services and the SQL server is on "automatic". If I start the SQL service manually, it fails by saying: Windows could not start the SQL server (MSSMLBIZ) on Local Computer. For more information, review the System Event Log. If this ia a non Microsoft service, contact the servie vendor, adn refer to service-specific error code 3417. After the failing installation of SQL update 2 package the hotfix information is: 03/31/2007 06:44:02.846 ================================================================================ 03/31/2007 06:44:02.850 Hotfix package launched 03/31/2007 06:44:02.876 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion" 03/31/2007 06:44:02.891 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files 03/31/2007 06:44:02.928 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion" 03/31/2007 06:44:02.931 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files 03/31/2007 06:44:02.951 Local Computer: 03/31/2007 06:44:02.960 Target Details: PC_PAPPA 03/31/2007 06:44:02.974 commonfilesdir = C:\Program Files\Common Files 03/31/2007 06:44:02.977 lcidsupportdir = c:\03506c4fea419ceefbab0a3b\1033 03/31/2007 06:44:02.985 programfilesdir = C:\Program Files 03/31/2007 06:44:03.011 programfilesdir_wow = C:\Program Files 03/31/2007 06:44:03.051 supportdir = c:\03506c4fea419ceefbab0a3b 03/31/2007 06:44:03.061 supportdirlocal = c:\03506c4fea419ceefbab0a3b 03/31/2007 06:44:03.086 windir = C:\Windows 03/31/2007 06:44:03.096 winsysdir = C:\Windows\system32 03/31/2007 06:44:03.099 winsysdir_wow = C:\Windows\SysWOW64 03/31/2007 06:44:03.126 03/31/2007 06:44:03.133 Enumerating applicable products for this patch 03/31/2007 06:44:03.168 Found SQL 2005 Express product definition 03/31/2007 06:44:07.126 Enumeration: Determining QFE level for product instance MSSMLBIZ 03/31/2007 06:44:07.190 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe 03/31/2007 06:44:07.210 Enumeration: Found following QFE level for product instance MSSMLBIZ: 2047 03/31/2007 06:44:07.218 Enumeration: Determining GDR branching Hotfix for product instance MSSMLBIZ 03/31/2007 06:44:07.245 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe 03/31/2007 06:44:07.301 Enumeration: No GDR branch Hotfix found for product instance MSSMLBIZ 03/31/2007 06:44:07.326 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion" 03/31/2007 06:44:07.345 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files 03/31/2007 06:44:07.379 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion" 03/31/2007 06:44:07.403 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files 03/31/2007 06:44:07.419 Product discovery completed during the install process for MSSMLBIZ 03/31/2007 06:44:07.445 SP Level check completed during the install process for MSSMLBIZ 03/31/2007 06:44:07.469 Product language check completed during the install process for MSSMLBIZ 03/31/2007 06:44:07.487 Product version check completed during the install process for MSSMLBIZ 03/31/2007 06:44:07.496 Command-line instance name check completed during the install process 03/31/2007 06:44:07.520 SKU check completed during the install process for MSSMLBIZ 03/31/2007 06:44:07.553 Baseline build check completed during the installation process for MSSMLBIZ 03/31/2007 06:44:07.609 Baseline build check completed during the install process 03/31/2007 06:44:07.673 Product Enumeration Results: 03/31/2007 06:44:07.696 INF File Name: c:\03506c4fea419ceefbab0a3b\HotFixExpress.inf 03/31/2007 06:44:07.712 baselinebuild = 1399 03/31/2007 06:44:07.737 build = 3042 03/31/2007 06:44:07.776 description = Express Database Services 03/31/2007 06:44:07.804 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search. 03/31/2007 06:44:07.843 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix 03/31/2007 06:44:07.871 kbarticle = KB921896 03/31/2007 06:44:07.929 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896 03/31/2007 06:44:07.980 lcid = 1033 03/31/2007 06:44:08.099 legalproductname = SQL Server Express Database Services 2005 03/31/2007 06:44:08.111 machinetype = x86 03/31/2007 06:44:08.117 package = HotFixExpress 03/31/2007 06:44:08.134 packagetype = SP 03/31/2007 06:44:08.160 productname = SQL9Express 03/31/2007 06:44:08.188 relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf 03/31/2007 06:44:08.202 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup 03/31/2007 06:44:08.208 sku = EXPRESS 03/31/2007 06:44:08.241 splevel = 2 03/31/2007 06:44:08.248 sqlutility = sqlcmd.exe 03/31/2007 06:44:08.262 supportdir = c:\03506c4fea419ceefbab0a3b 03/31/2007 06:44:08.280 validateauthentication = true 03/31/2007 06:44:08.295 version = 9 03/31/2007 06:44:08.301 03/31/2007 06:44:08.316 File Group Details: EXE 03/31/2007 06:44:08.327 parameters = INSTANCENAME=<NAME> 03/31/2007 06:44:08.332 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files 03/31/2007 06:44:08.357 File Details: SQLEXPR.EXE 03/31/2007 06:44:08.368 03/31/2007 06:44:08.378 Instance Details: MSSMLBIZ 03/31/2007 06:44:08.397 associatedhotfixbuild = 0 03/31/2007 06:44:08.404 clustername = 03/31/2007 06:44:08.415 features = SQL_Data_Files,SQL_Engine,SQL_SharedTools 03/31/2007 06:44:08.439 fullversion = 2005.090.2047.00 03/31/2007 06:44:08.446 hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1 03/31/2007 06:44:08.469 id = MSSQL.1 03/31/2007 06:44:08.481 installsqldatadir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL 03/31/2007 06:44:08.486 installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL 03/31/2007 06:44:08.502 lcid = 1033 03/31/2007 06:44:08.513 name = MSSMLBIZ 03/31/2007 06:44:08.535 productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} 03/31/2007 06:44:08.593 qfelevel = 2047 03/31/2007 06:44:08.612 servicename = MSSQL$MSSMLBIZ 03/31/2007 06:44:08.631 sku = EXPRESS 03/31/2007 06:44:08.656 sp = 1 03/31/2007 06:44:08.685 type = SQL Server Standalone Product 03/31/2007 06:44:08.695 vermajbld = 2047 03/31/2007 06:44:08.702 version = 9 03/31/2007 06:44:08.708 03/31/2007 06:44:08.713 Authenticating user using Windows Authentication 03/31/2007 06:44:08.745 SQL Service MSSQL$MSSMLBIZ was not previously running, started for authentication 03/31/2007 06:44:08.760 Starting service: MSSQL$MSSMLBIZ 03/31/2007 06:44:29.591 Unable to start service: MSSQL$MSSMLBIZ 03/31/2007 06:44:29.591 The following exception occurred: Unable to start service Date: 03/31/2007 06:44:29.591 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\service.cpp Line: 318 03/31/2007 06:44:29.592 The following exception occurred: Unable to start service Date: 03/31/2007 06:44:29.592 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\control.cpp Line: 2509 03/31/2007 06:44:29.593 The patch installation could not proceed due to unexpected errors 03/31/2007 06:44:30.316 Watson: Param1 = Unknown 03/31/2007 06:44:30.369 Watson: Param2 = 0x2b22 03/31/2007 06:44:30.370 Watson: Param3 = Unknown 03/31/2007 06:44:30.370 Watson: Param4 = Unknown 03/31/2007 06:44:30.371 Watson: Param5 = control.cpp(a)2509 03/31/2007 06:44:30.371 Watson: Param6 = Unknown 03/31/2007 06:44:30.372 Watson: Param7 = SQL9Express 03/31/2007 06:44:30.372 Watson: Param8 = @ 03/31/2007 06:44:30.373 Watson: Param9 = x86 03/31/2007 06:44:30.373 Watson: Param10 = 3042 Hopefully you can help. Thanks! Tony "Peter Saddow" wrote: > You need to run the SP2 Express update: > http://msdn.microsoft.com/vstudio/express/sql/download/ > > Or you can go to Microsoft Update > (http://msdn.microsoft.com/vstudio/express/sql/download/) and scan for the > correct update > > Thanks, > Peter Saddow > > > "Dr. George" <DrGeorge(a)discussions.microsoft.com> wrote in message > news:81843193-C40C-43F1-B9EB-CCDE9D1CA894(a)microsoft.com... > > The summary.txt file that I posted on 3/20/07 (see above) shows that my > > MS...BIZ file is not eligible for the SP2 update. I don't understand why. > > The remainder of the information that the .txt file shows could be > > correct. > > I don't really know what it is supposed to look like. By the way, the SP2 > > update won't install on my two home computers, my mother-in-law's new > > computer, and my brother's three computers. > > > > "PeterSadd" wrote: > > > >> The summary.txt file should not be very big. Do you see any errors in > >> this > >> file? > >> > >> Thanks, > >> Peter Saddow > >> > >> -- > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> > >> "Dr. George" <DrGeorge(a)discussions.microsoft.com> wrote in message > >> news:2BE2079D-57EF-496A-A35A-4AA4FF6704F7(a)microsoft.com... > >> > The log file that you suggested is too big to post. > >> > >> > > >
From: Adam P on 3 Apr 2007 06:14 I have also been struggling with the inability to update this SP, however have stumbled upon a solution that appears to have worked. I am running Vista and after reading Peter Saddow's comments, I went to the services folder and right mouse clicked on all four entries for SQL Server, those being (MSSMLBIZ); Active Directory; Browser; & VSS Writer. In the properties tab I change all of them to "Automatic", then went to the "Log On" tab and checked "Local System Account" then checked the "Allow service to interact with desktop". Click Apply and OK. After doing this, I then reopened Windows update, asked to install the update and it worked. I would like to hear if this works for others. -- Adam "Dr. George" wrote: > Here is the easiest method to resolve the problem with downloading and > installing Vista Windows Update for KB921896 - Microsoft SQL Server 2005 SP2 > Update. Go to Control Panel-->Programs and Features and uninstall the > existing entry that is named Microsoft SQL Server 2005. Restart your > computer. Then go to http://msdn.microsoft.com/vstudio/express/sql/download/ > and download and install Microsoft SQL Server 2005 Express Edition with > Advance Services Service Pack 2. During installation, you may notice a > message about Windows Internet Information Service (IIS). Ignore it, and > continue with the installation. When you are done, SQL Server 2005 SP2 will > be installed, and the Vista Windows Update for KB921896 will automatically be > eliminated from the Windows Update list. If you have a PDA that uses the > Windows Mobile operating system, activate the SQL Server Configuration > Manager, click on the arrow next to SQL Server 2005 Network Configuration. > Then click on Protocols for SQLEXPRESS. Protocols and their status should > appear on the right side of the window. Right click on Named Pipes, select > "enable". To check on the SQL service, click on SQL Server 2005 Services in > the configuration manager. The SQL Server (SQLEXPRESS) should be running and > have an automatic start mode. Hopefully it will work properly for you. I am > still unable to get Microsoft Outlook 2007 Business Contact Manager to work > for me. By the way, when I tried to activate IIS, my machine became a > network server. This disabled my printers and made things very complicated.
From: Outsider on 8 Apr 2007 12:00 I am not comfortable (even though qualified) to make such changes. The whole Update process is to make sure such things dont have to be done. How different is this from any other OS? Its a pity this problem has persisted for more than a month and we still dont have a fix for it. Every night my laptop asks me to reboot since it needs to install this uninstallable update. PITA really. "Adam P" wrote: > I have also been struggling with the inability to update this SP, however > have stumbled upon a solution that appears to have worked. > I am running Vista and after reading Peter Saddow's comments, I went to the > services folder and right mouse clicked on all four entries for SQL Server, > those being (MSSMLBIZ); Active Directory; Browser; & VSS Writer. > In the properties tab I change all of them to "Automatic", then went to the > "Log On" tab and checked "Local System Account" then checked the "Allow > service to interact with desktop". > Click Apply and OK. > After doing this, I then reopened Windows update, asked to install the > update and it worked. > I would like to hear if this works for others. > > -- > Adam > > > "Dr. George" wrote: > > > Here is the easiest method to resolve the problem with downloading and > > installing Vista Windows Update for KB921896 - Microsoft SQL Server 2005 SP2 > > Update. Go to Control Panel-->Programs and Features and uninstall the > > existing entry that is named Microsoft SQL Server 2005. Restart your > > computer. Then go to http://msdn.microsoft.com/vstudio/express/sql/download/ > > and download and install Microsoft SQL Server 2005 Express Edition with > > Advance Services Service Pack 2. During installation, you may notice a > > message about Windows Internet Information Service (IIS). Ignore it, and > > continue with the installation. When you are done, SQL Server 2005 SP2 will > > be installed, and the Vista Windows Update for KB921896 will automatically be > > eliminated from the Windows Update list. If you have a PDA that uses the > > Windows Mobile operating system, activate the SQL Server Configuration > > Manager, click on the arrow next to SQL Server 2005 Network Configuration. > > Then click on Protocols for SQLEXPRESS. Protocols and their status should > > appear on the right side of the window. Right click on Named Pipes, select > > "enable". To check on the SQL service, click on SQL Server 2005 Services in > > the configuration manager. The SQL Server (SQLEXPRESS) should be running and > > have an automatic start mode. Hopefully it will work properly for you. I am > > still unable to get Microsoft Outlook 2007 Business Contact Manager to work > > for me. By the way, when I tried to activate IIS, my machine became a > > network server. This disabled my printers and made things very complicated.
From: Dr. George on 8 Apr 2007 21:58
I uninstalled the original Microsoft SQL Server 2005 Express that was on my computer and wouldn't accept the Vista Windows Update for SQL 2005 SP2. Then I installed Microsoft SQL Server 2005 Express Service Pack 2 from the Microsoft website. Afterwards, the Windows Vista Update notice for SQL SP2 no longer appeared on my update list. However, the SQL Server is no longer MSSMLBIZ; it now shows SQLEXPRESS. Each of the three services in SQL Server Configuraton Manager are running and set to automatic. When I set the service log on properties for a built-in account, I am unable to get MS Outlook 2007 Business Contact Manager to "communicate with the server" regardless of which setting I use (Network Service, Local Service, or Local System). I think that I need a Microsoft Certified Technician to visit... |