Updation of MSSQL 2000 version 8.00.194 to 8.00.760

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Updation of MSSQL 2000 version 8.00.194 to 8.00.760

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-19 : 07:39:46

Mehvish writes "I have installed MS SQL 2000 version 8.00.194 I want to update it to 8.00.760 to be compactible with sqljdbc 1.0 driver. My Operating System is Windows XP 2003.

Please do guide me how to accomplish the above mentioned task.

Thank you"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 08:19:39

Any SQL Server 2000 version below Service Pack 4, is NOT recommended running on Windows Server 2003.

Update to SQL Server 2000 Service Pack 4 and use SQLjdbc driver with information found here http://msdn.microsoft.com/data/ref/jdbc/

Peter Larsson
Helsingborg, Sweden

EugeneZ
Starting Member

26 Posts

Posted - 2006-09-19 : 17:46:08

sql server 2000 with sp3a (8.00.760) is working just fine on windows 2003
and xp
just install recommended sql server security patch 818
http://support.microsoft.com/kb/821277/

read Instructions: SQL Server 2000 Driver for JDBC Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en

EugeneZ
Starting Member

26 Posts

Posted - 2006-09-19 : 17:47:12

sure - if you can install sp4 - just test it before - some apps do not work with sp4 for sql server 2000

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-19 : 18:31:42

quote:
Originally posted by Peso

Any SQL Server 2000 version below Service Pack 4, is NOT recommended running on Windows Server 2003.

I'll have to disagree with this. The minimum version of SQL Server 2000 that you should be running is service pack 3a plus security patch 818. There is nothing in service pack 4 that impacts us. Also, the amount of problems that people have experienced with sp4 has kept us away from it due to the amount of testing we'd have to do in order to roll it out into production.

So sp3a with security patch 818 at a minimum and sp4 if you've tested it.

Tara Kizer

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-09-19 : 19:25:52

jtds is better than sqljdbc imho. You can read about and download this software from here: http://jtds.sourceforge.net/

In regards to upgrading SQL Server to SP3a or SP4, I suggest you go with SP4 since it will be supported longer then SP3a. However, if testing shows that SP4 gives your application problems then go with tara's suggestion of build 818. Since your specific question is how to do this upgrade I will outline the steps for you below. There are very detailed readme.html files included in the Service Pack downloads, I recommend that you read through them very carefully.

So, in a nutshell here are the abbreviated directions. If you want to upgrade to SP3a plus hotfix 818 you will need to do the following:

Download service pack 3a (for build 760) here: http://www.microsoft.com/downloads/details.aspx?FamilyID=90DCD52C-0488-4E46-AFBF-ACACE5369FA3

Download the 818 (MS03-031) hotfix here: http://search.support.microsoft.com/kb/821277/

Install SP3a, reboot, then install the 818 hotfix, reboot. done.

If you want to go to SP4 instead of SP3a (Peso's recommendation) then follow these instructions:

Download SP4 here: http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5

*** RECOMMENDED *** Download cumulative hotfix 2187 from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=9c9ab140-bdee-44df-b7a3-e6849297754a

Install SP4, reboot, install hotfix 2187, reboot. done.

Build 2187 is not required, but it has fixed a number of issues that we have encountered so I recommend it. YMMV.

PLEASE NOTE: When you double-click the service pack that you have downloaded it will extract itself into a directory on your C: drive. This does not mean it is installed. You need to navigate into that directory and run the "setup.bat" in order to install the update package.

-ec

Luis Martin
Yak Posting Veteran

54 Posts

Posted - 2006-09-19 : 20:13:49

My suggestion is to begin with sp3a and patch 818.
After that test sp4 before to install to production server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources