sqlserver 2000 sp4 issue

Question

Post reply

sqlserver 2000 sp4 issue

sivark1

SSCrazy

Points: 2654
More actions
August 28, 2009 at 6:40 am

#225547

Hi experts
i am running a sqlserver 2000 sp2 now i need to install sp4 pls give the
sp path and pls give the procedure to do this task
i tried to install sp4 after installation also when i run select @@version
still it is showing sp2 only
pls help immediatly
Thanks in advance

Viewing 12 posts - 1 through 11 (of 11 total)

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

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 1

have you rebooted the box? it's been a while since i did this, but sp4 does require a reboot.

sivark1 SSCrazy Points: 2654 More actions · Answer 2

i have rebooted the server it is live server(production server)

some more information

iam using

i need to update sp2 to sp4 pls help with

Thanks in advance

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 3

You have upgraded to SP4 (8.00.2039).

Run the following query to confirm. The SP2 is the OS version.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

RTM - 2000.80.194.0

SP1 - 2000.80.384.0

SP2 - 2000.80.534.0

SP3 - 2000.80.760.0

SP3a - 2000.80.760.0

SP4 - 2000.8.00.2039

sivark1 SSCrazy Points: 2654 More actions · Answer 4

Thanks for support

its working fine

Thanks very much

sivark1 SSCrazy Points: 2654 More actions · Answer 5

Hi

Thanks for above responce

still some more clarification please

is there any problem with SQL 2000 server DB in xxxxx server as we have applied service pack 4 for SQL 2000 server, does that affected any user or system Databases access or anything?

thanks in advance

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 6

SA-1

SSCrazy Eights

Points: 8113

August 31, 2009 at 6:38 am

#1046829

Are you seeing any issues?

sivark1 SSCrazy Points: 2654 More actions · Answer 7

Hi issue is when thay try to connect database from front end application

getting error like this :

connection failed please check with database connection settings and network setting

i have one more named instance on the same server

so i need to upgreade sp2 to sp4 for this instance also ?

when i check the version with above post query it is showing

8.00.194RTMPersonal Edition

pls suggest for solution.

Thanks in advance

sivark1 SSCrazy Points: 2654 More actions · Answer 8

sivark1

SSCrazy

Points: 2654

September 2, 2009 at 4:10 am

#1048002

Hi Experts

pls update

Thanks in advance

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 9

That's a very generic error

- trying pinging the database server from the machine you're getting the error, even try connecting from a different client machine

- look at the sql logs to see if any errors are reported

- you mentioned there are 2 instances on the database server - are you running the query against the instance you have applied sp4 to?

- alternately you can open EM and make sure the account you're trying to connect with has access to sql

- also open EM and right click on the instance you applied SP4 to and in the properties look for the SP on the Product Version on the general tab

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 10

Please note that there was a VERY important update to SP4 that you must apply if you use AWE.

As for connectivity problems, I recommend you get a professional to help you out. You can spend (and already have) days going back and forth on a forum to figure out something that may take only seconds or minutes to resolve with proper assistance.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Silverfox SSC-Insane Points: 23150 More actions · Answer 11

Do you still have an issue or have you fixed the connectivity for your named instance and service packed it ok?

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]