SQL Server 2000 Service pack 4 ?

Question

Post reply

SQL Server 2000 Service pack 4 ?

spectra

SSCarpal Tunnel

Points: 4120
More actions
October 10, 2006 at 7:23 am

#170663

How to download
SQL Server 2000 Service pack 4 ?
I am here
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
but bit confused which one to download for my 32-bit windows XP machine
please suggest me
File Name:File Size
ReadmeSql2k32asp4.htm
66 KB
Download
ReadmeSql2k32desksp4.htm
154 KB
Download
ReadmeSql2k32sp4.htm
163 KB
Download
ReadmeSql2k64sp4.htm
71 KB
Download
SQL2000.AS-KB884525-SP4-x86-ENU.EXE
44.4 MB
Download
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
78.5 MB
Download
SQL2000-KB884525-SP4-ia64-ENU.EXE
49.1 MB
Download
SQL2000-KB884525-SP4-x86-ENU.EXE
66.9 MB
I see sizes are also different..........which one i should download for my machine ?

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135387 More actions · Answer 1

did you install MSDE ? use SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

or did you install a personal edition ? use SQL2000-KB884525-SP4-x86-ENU.EXE

or did you install only client components ? use SQL2000-KB884525-SP4-x86-ENU.EXE

and do you also have Analysis server installed ? also install SQL2000.AS-KB884525-SP4-x86-ENU.EXE

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 2

http://imgfly.com/files/101006_104408/web.JPG

thats my SQL Server 2000 version.

can you please tell me , what i need to download ?

please provide me the download link

Holger Steidel SSChasing Mays Points: 602 More actions · Answer 3

Hi,

you need to download this:

SQL2000-KB884525-SP4-x86-ENU.EXE 66.9 MB

Just another tip after installing SP4 try to get the latest Hotfix and apply it also.

Have fun.

Regards,

Holger

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 4

before reading your post , i downloaded SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

and it did nothing.

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 5

the reason i want it is , i am getting an error

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"

i am already in the mixed mode (SQL Server authentication mode) and using id/pass as "sa" and "sa" for my developement.

i read in the net that may be i need to add service pack/patch .......this could remove the error .

what do you think ?

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 6

i am connecting it via WEbsphere and getting that error in the websphere server console.

debrucer1 SSCertifiable Points: 5366 More actions · Answer 7

you only need the hotfix to sp4 if you are running a machine with 4 GB RAM or more and have AWE turned on in OS and DB. Otherwise, the hotfix is not required.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

debrucer1 SSCertifiable Points: 5366 More actions · Answer 8

it is highly unlikely that SP 4 will fix that problem. Of course, if you are not already at 3 or 3a, you should be patching; but your error is probably something else.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

debrucer1 SSCertifiable Points: 5366 More actions · Answer 9

I cannot tell from this post what version you actually have... someone else responded with an answer; but it looks like you downloaded something else, which did nothing. What version of SQL Server 2000 are you running, and what operating system are you using?

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 10

>What version of SQL Server 2000 are you running,

ok...you tell me what command i need to trigger in my console to get your answer....i will post the result you need.

>and what >operating system are you using?

windows XP

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 11

Hi Holger

....this works perfectly man.

after downloading and installing the version you suggested everything worked fine!!

But, i still dont understand why did you suggest SQL2000-KB884525-SP4-x86-ENU.EXE 66.9 MB

How did you recognize it ?

please share the secret...i dont want to be dumb person....i want to know why i need this version out of all others listed above.....how did you fidn out that i exactly need this version ?

please anybody who knows tell methe answer.....thanks all.

debrucer1 SSCertifiable Points: 5366 More actions · Answer 12

select @@version

go

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

debrucer1 SSCertifiable Points: 5366 More actions · Answer 13

he guessed. you say it worked perfectly.

did it solve your trusted connection problem?

If so, was the problem still present right before installed the service pack?

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982