Re: Error installing (KB 921896)

You're welcome, Tom. So, if I have this right, by *right* clicking the setup file and choosing ' Run as Admin' the SP installed, correct ?

MowGreen [MVP 2003-2008]
===============
*-343-* FDNY
Never Forgotten
===============



tomb wrote:

Thanks. I believe I got it done. Setting to Manual did not allow me to install the program via Windows Update. But when I clicked on the setup file itself as Administrator, I was able to install (or I never got an error message and the install program finished).

Thanks.

Tom

"MowGreen [MVP]" wrote:


Set it to Manual and see if that helps any.
If no joy, suggest you post here for expert assistance:

SQL Server
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US


MowGreen [MVP 2003-2008]
===============
*-343-* FDNY
Never Forgotten
===============


tomb wrote:


Both are set to automatic. MSSMLBIZ will not start, however . . . it tries to but stops short with the message that it runs only when a needed program is running.

Tom

"MowGreen [MVP]" wrote:



03/20/2008 03:01:55.020 SQL Service MSSQL$MSSMLBIZ was not previously running, started for authentication
03/20/2008 03:01:55.042 Starting service: MSSQL$MSSMLBIZ
03/20/2008 03:02:01.273 Unable to start service: MSSQL$MSSMLBIZ

Open the Services console and make sure that both MSSQL services are set to Automatic for Startup type.
Start > Run > type in and then click OK or press Enter to open the Services console.

services.msc


MowGreen [MVP 2003-2008]
===============
*-343-* FDNY
Never Forgotten
===============



tomb wrote:


I, too, am having the same installation failure for SQL Server 2005, which has been trying to install for some time. I've tried downloading the free standing file, which ends up failing in the same way, despite installing as administrator. If it's important to have this, please help. The latest log file is here . . .

03/20/2008 03:01:41.021 ================================================================================
03/20/2008 03:01:41.235 Hotfix package launched
03/20/2008 03:01:41.313 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:41.371 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/20/2008 03:01:41.437 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:41.514 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/20/2008 03:01:41.689 Local Computer:
03/20/2008 03:01:41.853 Target Details: DCJ95981
03/20/2008 03:01:41.886 commonfilesdir = C:\Program Files\Common Files
03/20/2008 03:01:41.978 lcidsupportdir = c:\c3df463aabb745ccc86b83a6\1033
03/20/2008 03:01:42.081 programfilesdir = C:\Program Files
03/20/2008 03:01:42.172 programfilesdir_wow = C:\Program Files
03/20/2008 03:01:42.221 supportdir = c:\c3df463aabb745ccc86b83a6
03/20/2008 03:01:42.294 supportdirlocal = c:\c3df463aabb745ccc86b83a6
03/20/2008 03:01:42.320 windir = C:\Windows
03/20/2008 03:01:42.357 winsysdir = C:\Windows\system32
03/20/2008 03:01:42.379 winsysdir_wow = C:\Windows\SysWOW64
03/20/2008 03:01:42.399 03/20/2008 03:01:42.449 Enumerating applicable products for this patch
03/20/2008 03:01:42.484 Found SQL 2005 Express product definition
03/20/2008 03:01:49.795 Enumeration: Determining QFE level for product instance MSSMLBIZ
03/20/2008 03:01:49.889 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
03/20/2008 03:01:49.925 Enumeration: Found following QFE level for product instance MSSMLBIZ: 2047
03/20/2008 03:01:49.945 Enumeration: Determining GDR branching Hotfix for product instance MSSMLBIZ
03/20/2008 03:01:49.972 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
03/20/2008 03:01:50.134 Enumeration: No GDR branch Hotfix found for product instance MSSMLBIZ
03/20/2008 03:01:50.163 Enumeration: Determining QFE level for product instance SQLEXPRESS
03/20/2008 03:01:50.189 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\SQLServr.exe
03/20/2008 03:01:50.204 Enumeration: Found following QFE level for product instance SQLEXPRESS: 2047
03/20/2008 03:01:50.226 Enumeration: Determining GDR branching Hotfix for product instance SQLEXPRESS
03/20/2008 03:01:50.251 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\SQLServr.exe
03/20/2008 03:01:50.272 Enumeration: No GDR branch Hotfix found for product instance SQLEXPRESS
03/20/2008 03:01:50.288 Enumeration: Determining QFE level for product instance 03/20/2008 03:01:50.310 Enumeration: Cannot find following key file for product instance : c:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
03/20/2008 03:01:50.329 Enumeration: Determining GDR branching Hotfix for product instance 03/20/2008 03:01:50.352 Enumeration: Cannot find following key file for product instance : c:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
03/20/2008 03:01:50.405 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:50.426 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/20/2008 03:01:50.447 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:50.476 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/20/2008 03:01:50.555 Product discovery completed during the install process for MSSMLBIZ
03/20/2008 03:01:50.613 SP Level check completed during the install process for MSSMLBIZ
03/20/2008 03:01:50.651 Product language check completed during the install process for MSSMLBIZ
03/20/2008 03:01:50.727 Product version check completed during the install process for MSSMLBIZ
03/20/2008 03:01:50.767 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:50.793 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/20/2008 03:01:50.818 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:50.843 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/20/2008 03:01:50.867 Product discovery completed during the install process for SQLEXPRESS
03/20/2008 03:01:50.893 SP Level check completed during the install process for SQLEXPRESS
03/20/2008 03:01:50.917 Product language check completed during the install process for SQLEXPRESS
03/20/2008 03:01:50.943 Product version check completed during the install process for SQLEXPRESS
03/20/2008 03:01:50.967 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:50.993 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/20/2008 03:01:51.018 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/20/2008 03:01:51.044 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/20/2008 03:01:51.068 Product discovery completed during the install process for SQLExpress
03/20/2008 03:01:51.117 SP Level check completed during the install process for SQLExpress
03/20/2008 03:01:51.164 Product language check completed during the install process for SQLExpress
03/20/2008 03:01:51.219 Product version check completed during the install process for SQLExpress
03/20/2008 03:01:51.278 Command-line instance name check completed during the install process
03/20/2008 03:01:51.344 SKU check completed during the install process for MSSMLBIZ
03/20/2008 03:01:51.402 SKU check completed during the install process for SQLEXPRESS
03/20/2008 03:01:51.475 The edition of product instance SQLExpress does not qualify for this update.
03/20/2008 03:01:51.611 Baseline build check completed during the installation process for MSSMLBIZ
03/20/2008 03:01:51.635 Baseline build check completed during the installation process for SQLEXPRESS
03/20/2008 03:01:51.661 Baseline build check completed during the install process
03/20/2008 03:01:51.687 Product Enumeration Results:
03/20/2008 03:01:51.711 INF File Name: c:\c3df463aabb745ccc86b83a6\HotFixExpress.inf
03/20/2008 03:01:51.735 baselinebuild = 1399
03/20/2008 03:01:51.762 build = 3042
03/20/2008 03:01:51.785 description = Express Database Services
03/20/2008 03:01:51.812 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
03/20/2008 03:01:51.835 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
03/20/2008 03:01:51.885 kbarticle = KB921896
03/20/2008 03:01:51.945 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
03/20/2008 03:01:51.994 lcid = 1033
03/20/2008 03:01:52.020 legalproductname = SQL Server Express Database Services 2005
03/20/2008 03:01:52.044 machinetype = x86
03/20/2008 03:01:52.070 package = HotFixExpress
03/20/2008 03:01:52.094 packagetype = SP
03/20/2008 03:01:52.120 productname = SQL9Express
03/20/2008 03:01:52.144 relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
03/20/2008 03:01:52.170 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
03/20/2008 03:01:52.194 sku = EXPRESS
03/20/2008 03:01:52.221 splevel = 2
03/20/2008 03:01:52.261 sqlutility = sqlcmd.exe
03/20/2008 03:01:52.306 supportdir = c:\c3df463aabb745ccc86b83a6
03/20/2008 03:01:52.337 validateauthentication = true
03/20/2008 03:01:52.361 version = 9
03/20/2008 03:01:52.388 03/20/2008 03:01:52.411 File Group Details: EXE
03/20/2008 03:01:52.438 parameters = INSTANCENAME=<NAME>
03/20/2008 03:01:52.461 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
03/20/2008 03:01:52.504 File Details: SQLEXPR.EXE
03/20/2008 03:01:52.585 03/20/2008 03:01:52.651 Instance Details: MSSMLBIZ
03/20/2008 03:01:52.695 associatedhotfixbuild = 0
03/20/2008 03:01:52.738 clustername = 03/20/2008 03:01:52.771 features = SQL_Data_Files,SQL_Engine,SQL_SharedTools
03/20/2008 03:01:52.797 fullversion = 2005.090.2047.00
03/20/2008 03:01:52.861 hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1
03/20/2008 03:01:52.947 id = MSSQL.1
03/20/2008 03:01:53.019 installsqldatadir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
03/20/2008 03:01:53.084 installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
03/20/2008 03:01:53.160 lcid = 1033
03/20/2008 03:01:53.214 name = MSSMLBIZ
03/20/2008 03:01:53.238 productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
03/20/2008 03:01:53.264 qfelevel = 2047
03/20/2008 03:01:53.289 servicename = MSSQL$MSSMLBIZ
03/20/2008 03:01:53.314 sku = EXPRESS
03/20/2008 03:01:53.339 sp = 1
03/20/2008 03:01:53.364 type = SQL Server Standalone Product
03/20/2008 03:01:53.389 vermajbld = 2047
03/20/2008 03:01:53.414 version = 9
03/20/2008 03:01:53.439 03/20/2008 03:01:53.506 Instance Details: SQLEXPRESS
03/20/2008 03:01:53.590 associatedhotfixbuild = 0
03/20/2008 03:01:53.631 clustername = 03/20/2008 03:01:53.702 features = SQL_Data_Files,SQL_Engine,SQL_SharedTools
03/20/2008 03:01:53.782 fullversion = 2005.090.2047.00
03/20/2008 03:01:53.889 hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.2
03/20/2008 03:01:53.949 id = MSSQL.2
03/20/2008 03:01:53.990 installsqldatadir = c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL
03/20/2008 03:01:54.015 installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL
03/20/2008 03:01:54.040 lcid = 1033
03/20/2008 03:01:54.065 name = SQLEXPRESS
03/20/2008 03:01:54.090 productcode = {6DEF11C0-35FF-4160-A543-FDD336C4DAE5}
03/20/2008 03:01:54.115 qfelevel = 2047
03/20/2008 03:01:54.140 servicename = MSSQL$SQLEXPRESS
03/20/2008 03:01:54.166 sku = EXPRESS
03/20/2008 03:01:54.190 sp = 1
03/20/2008 03:01:54.216 type = SQL Server Standalone Product
03/20/2008 03:01:54.240 vermajbld = 2047
03/20/2008 03:01:54.266 version = 9
03/20/2008 03:01:54.290 03/20/2008 03:01:54.316 Instance Details: SQLExpress
03/20/2008 03:01:54.366 associatedhotfixbuild = 1520
03/20/2008 03:01:54.391 clustername = 03/20/2008 03:01:54.416 details = The edition of product instance SQLExpress does not qualify for this update.
03/20/2008 03:01:54.441 expressrsstandalone = true
03/20/2008 03:01:54.488 features = Client_Components,Connectivity
03/20/2008 03:01:54.557 hiveregpath = Software\Microsoft\Microsoft SQL Server\90\Tools
03/20/2008 03:01:54.609 id = 03/20/2008 03:01:54.649 installsqldatadir = 03/20/2008 03:01:54.675 installsqldir = c:\Program Files\Microsoft SQL Server\90\Tools\
03/20/2008 03:01:54.699 lcid = 1033
03/20/2008 03:01:54.725 name = 03/20/2008 03:01:54.775 productcode = {58D379F7-62BC-4748-8237-FE071ECE797C}
03/20/2008 03:01:54.800 servicename = MSSQL$
03/20/2008 03:01:54.825 sku = EXPRESS_ADVANCED
03/20/2008 03:01:54.851 sp = 2
03/20/2008 03:01:54.875 type = Tools Only
03/20/2008 03:01:54.897 vermajbld = 3042
03/20/2008 03:01:54.916 version = 9
03/20/2008 03:01:54.942 03/20/2008 03:01:54.988 Authenticating user using Windows Authentication
03/20/2008 03:01:55.020 SQL Service MSSQL$MSSMLBIZ was not previously running, started for authentication
03/20/2008 03:01:55.042 Starting service: MSSQL$MSSMLBIZ
03/20/2008 03:02:01.273 Unable to start service: MSSQL$MSSMLBIZ
03/20/2008 03:02:01.303 The following exception occurred: Unable to start service Date: 03/20/2008 03:02:01.303 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\service.cpp Line: 318
03/20/2008 03:02:01.328 The following exception occurred: Unable to start service Date: 03/20/2008 03:02:01.327 File:
.

Relevant Pages

  • Re: Trying to patch SQL 2005 Developer SP2 Build 3033 - failing
    ... This SP2 reinstall appears to work - great answer! ... I was able to install the security patch afterwards. ... The product instance MSSQLSERVER has had update 3033 applied. ... Update 3159 is dependent on prerequisite update 3042. ...
    (microsoft.public.sqlserver.security)
  • Re: Trying to patch SQL 2005 Developer SP2 Build 3033 - failing
    ... Ekrem Önsoy ... I was able to install the security patch afterwards. ... > The product instance MSSQLSERVER has had update 3033 applied. ... Update 3159 is dependent on prerequisite update 3042. ...
    (microsoft.public.sqlserver.security)
  • Re: Trying to patch SQL 2005 Developer SP2 Build 3033 - failing
    ... The product instance MSSQLSERVER has had update 3033 applied. ... install GDR update 3054 overtop update 3033. ... Update 3159 is dependent on prerequisite update 3042. ...
    (microsoft.public.sqlserver.security)
  • Re: Trying to patch SQL 2005 Developer SP2 Build 3033 - failing
    ... I was able to install the security patch afterwards. ... The product instance MSSQLSERVER has had update 3033 applied. ... Update 3159 is dependent on prerequisite update 3042. ...
    (microsoft.public.sqlserver.security)
  • Re: Error installing (KB 921896)
    ... 03/20/2008 03:01:49.925 Enumeration: Found following QFE level for product instance MSSMLBIZ: 2047 ... 03/20/2008 03:01:50.204 Enumeration: Found following QFE level for product instance SQLEXPRESS: 2047 ... 03/20/2008 03:01:50.555 Product discovery completed during the install process for MSSMLBIZ ...
    (microsoft.public.windowsupdate)
Quantcast