Post reply

sqlserver 2000 sp4 issue

  • 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

  • August 28, 2009 at 6:50 am

    #1046158

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

  • August 28, 2009 at 7:06 am

    #1046167

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

    some more information

    iam using

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    i need to update sp2 to sp4 pls help with

    Thanks in advance

  • August 28, 2009 at 7:17 am

    #1046179

    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

  • August 31, 2009 at 12:51 am

    #1046736

    Thanks for support

    its working fine

    Thanks very much

  • August 31, 2009 at 6:35 am

    #1046828

    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

  • August 31, 2009 at 6:38 am

    #1046829

    Are you seeing any issues?

  • September 1, 2009 at 1:14 am

    #1047331

    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

  • September 2, 2009 at 4:10 am

    #1048002

    Hi Experts

    pls update

    Thanks in advance

  • September 2, 2009 at 7:35 am

    #1048118

    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

  • September 3, 2009 at 7:28 am

    #1048718

    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

  • September 3, 2009 at 7:40 am

    #1048728

    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]

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

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