For some reason, whenever Windows or I try to install Security Update for
SQL Server 2005 Service Pack 2 (KB960089), it says the installation has
failed. I tried downloading SP2 for SQL Server 2005, and only one part of SQL
Server which I cannot recall was updated to SP2. I have tried for many months
to install the security update for SP2, but it still cannot update. When I
look at the update history for these attempted updates, I find the error
code 0x2B08.

http://msdn.microsoft.com/en-us/libr...(PROT.13).aspx
2B08 An invalid or unrecognized service type was found in the flowspec.

Because of this, I rightclicked My Computer, and then went to Manage >
Services and Applications > Services . I found SQL Server Browser and SQL
Server Active Directory Helper were disabled. So I changed their startup
types to automatic. I was thus able to start Browser, but I could not run
Active Directory Helper. I restarted my computer, and still Active Directory
Helper did not run. Whenever I try to start Active Directory Helper, a popup
message says:

Windows could not start the SQL Server Active Directory Helper on Local
Computer. For more information, review the System Event Log. If this is a
non-Microsoft service, contact the service vendor, and refer to
service-specific error code -1073741724

In Event Viewer > Application, I saw many informational events that come
from the source MSSQL$SQLEXPRESS. Errors from MSSQLServerADHelper said this:
"'0' is an invalid number of start up parameters. This service takes two start
up parameters." (without quotations)
Warnings from SQL Browser say: "The configuration of the Admin
Connection\TCP protocol in the SQL instance SQLEXPRESS is not valid."

As well, whenever I try to run SQL Server Error and Usage Reporting, I get a
message saying that SQL Server Error and Usage Reporting has encountered a
problem and needs to close. Please help, as the main problem continues to
persist, and if this helps: I use Windows
XP Home Edition SP3 (SP3 was installed while this problem was occuring), and
I have Microsoft SQL Server 2005.

I found that the error from MSSQLServerADHelper had an Event ID 100. I also
found a website, http://www.sqlcoffee.com/Troubleshooting005.htm, telling me
that MSSQLServerADHelper should be set to manual start up type, as SQL Server
will start and stop the service by itself when needed. It linked
http://msdn2.microsoft.com/en-us/lib...7(sql.80).aspx as a source of
this information, and I checked - the information was indeed on the Microsoft
website. Therefore, I changed the startup type of the service to Manual, and
tried to install Security Update for SQL Server 2005 Service Pack 2 again.
The update failed again. In the update history, I found the last failed
update also had the error code 0x2B08.

"Chocolitz58" wrote:

Chocolitz58 (Chocolitz58 (AT) discussions (DOT) microsoft.com) writes:
Not that I'm sure that it's going to work out any better, but I think you
should download and try to install Service Pack 3 for SQL 2005, rather than
battling with a security fix for SP2.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I thank you for your suggestion, but I am wondering what SP3 will do to SP2.
Will SP3 remove and replace SP2?

"Erland Sommarskog" wrote:

SPs are cumulative... Everything that is in SP2 will also be in SP3. There
is nothing to remove / replace.


On 8/13/09 10:58 PM, in article
85A3FD9A-A86A-4E0A-AF37-51B5B6C679FA...soft (DOT) com, "Chocolitz58"
<Chocolitz58 (AT) discussions (DOT) microsoft.com> wrote: