Upgrade to SP3

[zas1]

Hi, I have SQL Server 2000 SP2 with W2KServerSP2. I want upgrade to: W2Kserver SP4 and SQL Server SP3.

Can I have any problem?

Thanks.

 

[mrdenny]

Nope you should be fine. You'll want to upgrade to SP3a however.

You might want to think about upgrading directly to SQL 2000 SP4.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[SQLBill]

Problem? Maybe, but not a big one.

SP3a requires you to have a strong password for the SA account.

If you don't have a strong password, SP3a will complain, but just click OK or CONTINUE (I forget which one it is) and continue with the installation. ONCE THE INSTALL IS DONE, give the SA account a strong password. This is probably one of (if not THE) most important things you can do to protect your SQL Server installation.

-SQLBill

Posting advice: FAQ481-4875

 

[zas1]

Hi, thanks everybody for reply.

The password of sa is "sasa", can I have problem with this password?

What do you mean with "strong password".

Thanks.

 

[gmmastros]

First and formost, the password you assign should not be made common knowledge by posting it on a website.

Here's a link to an article that may help you decide on a strong password.

http://www.microsoft.com/athome/security/privacy/password.mspx

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

The basic definition of a strong password is this.

Use a password at least 8 characters in length with characters for at least 3 of the following categories.

Lower case letters
Upper case letters
numbers
Symbols

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[zas1]

Hi, OK

thanks everybody.

 

[SQLBill]

So, yes having a password of sasa is BAD and very weak.

-SQLBill

Posting advice: FAQ481-4875