SQL Server SP3 problems

[John Bell]

Hi
Which version of SQL Server are you trying to update?

Only apply the files needed.

a.. Sql2ksp3.exe. Updates for database components.
b.. Sql2kasp3.exe. Updates for Analysis Services components.
c.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
If you are not using MSDE and don't have Analysis Services run sqlksp3.exe
only. It sounds like the MSDE update is trying to install a new instance.
Make sure that you read the readme first!

John


"Robb Meade" <robb.meade@NOSPAMkingswoodweb.net> wrote in message
news:u7WNa.3399$i94.24222939@news-text.cableinet.net...

> Hi all,
>
> I've followed the instructions on the MS web site, but have ran into a few
> problems.
>
> I downloaded all 3 files individually
>
> I installed the sql2k.exe first, then I tried the sqlasp.exe (which
> failed) - I think this might be because I dont have the analysis services
> installed (but I'm not sure, and unsure where to check etc).
>
> I then tried to install the sqldesk.exe file, this errored almost
> immediately with the following error :
>
> "A strong SA password is required for security reasons. Please use SAPWD
> switch to supply the same. Refer to the readme for more details. Setup

will

> now exit"
>
> How rude! :o)
>
> Ok, my SA password is perhaps not as secure is it should be, its not a
> series of letters and numbers and mixed case, instead a word secret to
> myself....so, for me to use the SAPWD switch - which I nothing about,

where

> would I find this? Will this allow me to change my SA password (affecting
> all of my SQL installation), and then will the sqldesk.exe install?
>
> Any help on this would be muchly appreciated,
>
> Thanks in advance, kind regards
>
> Robb Meade
>
>

[Erland Sommarskog]

Robb Meade (robb.meade@NOSPAMkingswoodweb.net) writes:

> I installed the sql2k.exe first, then I tried the sqlasp.exe (which
> failed) - I think this might be because I dont have the analysis services
> installed (but I'm not sure, and unsure where to check etc).

If you are unsure whether you have Analysis Services installed, you are not
likely to have it installed. Analysis Services is for data warehousing,
OLAP, data mining and that sort of stuff.



--
Erland Sommarskog, SQL Server MVP, [email]sommar@algonet.se[/email]

Books Online for SQL Server SP3 at
[url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]