SQL Server 2000 Service Pack 3a installation fails

[Paul]

I have an installation of SQL Server 2000. Both MBSA and @@version
show this to be the gold release. When I install Service Pack 3a, it
shows no error. But after restart of the server, it's still unpatched,
by both MBSA and @@version.

Any idea what may be going on here?

[Erland Sommarskog]

Re: SQL Server 2000 Service Pack 3a installation fails

Paul (pnorris@itsa.u csf.edu) writes:[color=blue]
> I have an installation of SQL Server 2000. Both MBSA and @@version
> show this to be the gold release. When I install Service Pack 3a, it
> shows no error. But after restart of the server, it's still unpatched,
> by both MBSA and @@version.
>
> Any idea what may be going on here?[/color]

Do you happen to have several instances of SQL Server installed on the
machine?

(And what is MBSA?)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Paul]

Re: SQL Server 2000 Service Pack 3a installation fails

Erland,

MBSA = Microsoft Baseline Security Analyzer

I think there's only one instance. From Enterprise Manager, when I
select 'New SQL Server registration', only the one instance shows up.
Paul

[Erland Sommarskog]

Re: SQL Server 2000 Service Pack 3a installation fails

Paul (pnorris@itsa.u csf.edu) writes:[color=blue]
> MBSA = Microsoft Baseline Security Analyzer
>
> I think there's only one instance. From Enterprise Manager, when I
> select 'New SQL Server registration', only the one instance shows up.[/color]

Better to use the SQL Service Manager, or open Computer Management
and check Services.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp