Security Update for SQL Server 2005 Service Pack 2 (KB948109)

Good to know it's not just me having these problems, 6 restarts on my laptop
already today and outlook keeps loading in safe mode which of course means
i'm losing some functionalities, slightly frustrating as 2 hours in to my
working day at the office and nothing achieved as yet!! aaarrrgghh!!

Let's keep everything crossed for an extremely quick fix!!!! :{

> Good to know it's not just me having these problems, 6 restarts on my laptop
> already today and outlook keeps loading in safe mode which of course means
> i'm losing some functionalities, slightly frustrating as 2 hours in to my
> working day at the office and nothing achieved as yet!! aaarrrgghh!!

I just went through some of this on one of my servers. SQL Server had a few
services disabled ('cause I rarely require it). Chances are good that this is
what is wrong with you, too.

Right click My Computer, select Manage, Services and Applications, Services.
Now find everything that STARTS WITH "MSSQL" or "SQLAgent" that has a
"startup type" of "Disabled" and change their startup type to "Manual".

You will then be able to successfully install the related updates.

It will require a reboot. After it comes back up you can re-disable the
services if you want.

What a waste of time. Good luck!

-Shawn

Yes after spending much time trying to restart the services during the
install attempts i decided to forget it and disable them. Not great news for
Business Contact Manager though so it's a good job i don't need to use that
facility today.

Thanks for confirming my solution. I had posted this prior to disabling the
services mainly through frustration... let's say i needed to complain about
it!!

I'll try re-installing with all such services switched off and keep my
fingers crossed..

Have a good day....

"Shawn" wrote:

> > Good to know it's not just me having these problems, 6 restarts on my laptop
> > already today and outlook keeps loading in safe mode which of course means
> > i'm losing some functionalities, slightly frustrating as 2 hours in to my
> > working day at the office and nothing achieved as yet!! aaarrrgghh!!
>
> I just went through some of this on one of my servers. SQL Server had a few
> services disabled ('cause I rarely require it). Chances are good that this is
> what is wrong with you, too.
>
> Right click My Computer, select Manage, Services and Applications, Services.
> Now find everything that STARTS WITH "MSSQL" or "SQLAgent" that has a
> "startup type" of "Disabled" and change their startup type to "Manual".
>
> You will then be able to successfully install the related updates.
>
> It will require a reboot. After it comes back up you can re-disable the
> services if you want.
>
> What a waste of time. Good luck!
>
> -Shawn
>

> I'll try re-installing with all such services switched off and keep my
> fingers crossed..

They need to be set to "manual", not "disabled". If they're set to disabled
it will not work.

-Shawn

Ok Shawn thanks for clarifying that.

ms

"Shawn" wrote:

> > I'll try re-installing with all such services switched off and keep my
> > fingers crossed..
>
> They need to be set to "manual", not "disabled". If they're set to disabled
> it will not work.
>
> -Shawn
>

None of my SQL instances are disabled, but it still won't install via WSUS.

"Shawn" wrote:

> > I'll try re-installing with all such services switched off and keep my
> > fingers crossed..
>
> They need to be set to "manual", not "disabled". If they're set to disabled
> it will not work.
>
> -Shawn
>

hi Shawn

I had same problem with installing this update(KB948109) and tried the
'services' suggestion but they are all manual and I still can't update. error
message 0x783. Also the 'SQL Server Directory Active Helper' under 'Services'
will not allow me to start it. Can you make any suggestions.

Thanks
--
mickyg


"Shawn" wrote:

> > Good to know it's not just me having these problems, 6 restarts on my laptop
> > already today and outlook keeps loading in safe mode which of course means
> > i'm losing some functionalities, slightly frustrating as 2 hours in to my
> > working day at the office and nothing achieved as yet!! aaarrrgghh!!
>
> I just went through some of this on one of my servers. SQL Server had a few
> services disabled ('cause I rarely require it). Chances are good that this is
> what is wrong with you, too.
>
> Right click My Computer, select Manage, Services and Applications, Services.
> Now find everything that STARTS WITH "MSSQL" or "SQLAgent" that has a
> "startup type" of "Disabled" and change their startup type to "Manual".
>
> You will then be able to successfully install the related updates.
>
> It will require a reboot. After it comes back up you can re-disable the
> services if you want.
>
> What a waste of time. Good luck!
>
> -Shawn
>

mikegee wrote:
> hi Shawn
>
> I had same problem with installing this update(KB948109) and tried the
> 'services' suggestion but they are all manual and I still can't update. error
> message 0x783. Also the 'SQL Server Directory Active Helper' under 'Services'
> will not allow me to start it. Can you make any suggestions.
>
> Thanks

Hi,
exact the same problem here :-(


--
Juergen Heckel

"Juergen Heckel" wrote:

> mikegee wrote:
> > hi Shawn
> >
> > I had same problem with installing this update(KB948109) and tried the
> > 'services' suggestion but they are all manual and I still can't update. error
> > message 0x783. Also the 'SQL Server Directory Active Helper' under 'Services'
> > will not allow me to start it. Can you make any suggestions.
> >
> > Thanks
>
> Hi,
> exact the same problem here :-(
>
>
> --
> Juergen Heckel
>
>

Yeah, me too... This is EXTREMELY annoying...I can't get rid of the update
icon in the sys tray and it is always showing the red shut down and install
updates button... even after 10 'successful' updates.

From MS Support:

<QP>
Error: 733F-- Services Failed to Start

Description: This error occurs when the installation program can’t start the
SQL Server services. This can happen for several reasons including: expired
account password, invalid user account, user account does not have
permission to start the service, or there is something else wrong with the
service.

Resolution: To help you determine which service is failing to start, view
the summary.txt file that is created at...

%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix

Once you determine which service is failing, do the following:

1. Click Start, point to Settings, and then click Control Panel.

2. Double-click Administrative Tools, and then double-click Services.

3. Locate the SQL Server service causing the problem and try to manually
start the service.

4. If the service still does not start, try resetting the password or the
user account. After doing this, restart the service manually

More information, see: http://support.microsoft.com/kb/282254

If you need additional help, please post your summary.txt file located at

%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix

to the SQL Server Setup MSDN forum at
http://forums.microsoft.com/MSDN/Sho...ID=95&SiteID=1
</QP>
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002
AumHa VSOP & Admin http://aumha.net
DTS-L http://dts-l.net/

mizsub wrote:
> Good to know it's not just me having these problems, 6 restarts on my
> laptop
> already today and outlook keeps loading in safe mode which of course means
> i'm losing some functionalities, slightly frustrating as 2 hours in to my
> working day at the office and nothing achieved as yet!! aaarrrgghh!!
>
> Let's keep everything crossed for an extremely quick fix!!!! :{