Link to home
Create AccountLog in
Avatar of Trihimbulus
Trihimbulus

asked on

SP4 Upgrade Help and Steps

I am going to upgrade to SQL 2000 SP4 tonight and would like some advice as to what steps I need to follow to make sure this is done smoothly. Please do not link me to the KB article :)  The server is Win 2k3 SP1 w/ SQL 2000 SP3a.

It looks like I do NOT have analysis services installed. I looked under Start > All Programs > MS SQL and it is not under there. Is there somewhere else I can check? I did not initial;ly set this server up unfortunatley. So it looks like I will be installing the "SQL2000-KB884525-SP4-x86-ENU.EXE" on the MS download site.



Avatar of chapmandew
chapmandew
Flag of United States of America image

Is it on a cluster?
Avatar of Trihimbulus
Trihimbulus

ASKER

No Cluster - STandalane SQL 2004 SP3 Standard on Windows 2003 SP1 Single Server
Its really simple then...not much to tell.  Run the .EXE on the server and follow the steps.  It will give you the option to install AA and SSIS, and upgrade the database engine.  Its actually the easiest SQL install version yet.
AA and SSIS - What's that lol. Do I need to install these, and if so- what will it affect?

Also, as listed above, is this how I tell if I have analysis services installed? Do I need to stop any services when I perform this upgrade? Lastly, do I need to install any hotfies after the upgrade?
analysis services and integration services...you'll want to install them...just in case.

if you don't have 2005 installed already , then you won't have AA installed.
I'm confused as to why these weren't installed in the first place on this server. I really don't want to add anything unecessary. Is there a chance that the "SQL2000-KB884525-SP4-x86-ENU.EXE" which is :

Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)
Update your 32-bit Database components of SQL Server 2000 including Database Engine, Replication, Client Connectivity components and Tools. For additional information, please refer to ReadmeSql2k32Sp4.htm

will break something if these aren't installed?
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Sweet- thanks man!
No problem....hope it helps.
Tim
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup Zone:
Accept a Comment.

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

matrix_aash Experts Exchange Cleanup Volunteer
:)  which comment?
Sarcasm can be fantastic sometimes ;o)
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup Zone:
Accept chapmandew comment as answer

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

matrix_aash Experts Exchange Cleanup Volunteer