Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.
Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>
|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>