SP4 SQL Server 2k installation big problem. Help !!

  • Hi !

     

    I have a terrible annoying bug when I install the SP4.

    I have some SQL Server 2k  with replication. To correct other bugs, I must install the SP4.

     

    In almost all of my company‘s servers, The SP4 was installed without any problems but one of my server is really crazy.

     

    When I run the install, It doesn’t ask any questions. It doesn’t ask for authentication mode, for instance name. Nothing. It just ask for the CLUF and say that it have enough information to start the install.

     

    I start it but it just coping some files (2-3 temp files), registering activeX, etc.. Any important files are copied. At the end, it say that files are copied and doesn’t ask to reboot.

     

    When I go to the server properties, it’s always the SP3a and not the SP4. grrr…

     

    When I read the file sqlsp.log, two lines intrigues me.

     

    « 11:41:30 This machine has SQL Server 2000 SP4 already installed

    11:41:30 Version of installed Service Pack: 8.00.2039 »

     

    IT’S NOT TRUE !!  SP4 ISN’T ALREADY INSTALLED!!!!!

     

    How can I force the installation or correct this wrong information (that it’s already installed) ????

    Because I’m in a really stressed situation!

     

    Please! Help-me !!!

    Thanks

  • When you execute SELECT @@VERSION, what do you get back? Also, when you check the sqlservr.exe file, what does the file version say?

    K. Brian Kelley
    @kbriankelley

  • quote: At the end, it say that files are copied and doesn’t ask to reboot.

    Have you rebooted it anyways? I seem to recall that there is at least one condition where it won't ask to reboot - I think it's if the services are stopped. But there might be others.

    -SQLBill

  • I rebooted couple of time (each time that I try to install it). It doesn’t change the SP.

     

    SELECT @@version gives me that result

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)

     

    And sqlserv.exe is the old one (~7345 Ko and Not ~8936 Ko).

     

    The instance is installed on C:\Program Files\MSSQL and not in C:\Program Files\Microsoft Sql Server\MSSQL ….Maybe it can affect the installation but I don’t think so…

     

    I cannot reinstall the server…it’s too much work (and I already have a lot of work….) and I have a big replication topology…..

     

    Thanks for your help....Hope I will do it..

  • This is an MSDE instance. Are there any other instances of SQL Server on this machine?

    K. Brian Kelley
    @kbriankelley

  • I'll second BKelly's comment......I'll bet you have more than one instance and just keep updating the default instance. You MUST apply service packs to each instance even if they are on the same server.

    -SQLBill

  • Effectively, I think that MSDE is installed. But How can I specify the instance. If I uninstall MSDE. DO you think it will works ???

    I'll try.....

  • I believe that when you run the install there is a window where it asks for the instance and has a checkbox for default. Check or uncheck the box as needed. I believe when you uncheck it, it might then show a drop down with the named instances you have installed.

    -SQLBill

  • No. It doesn’t ask for the instance....it's the entire problem. It says directly that it have enough information to install.

     

    Hope it'll work this week-end. It's my time limit.........

  • Okay...I understand...My predecessor installed MSDE....Not SQL server 2000....I will try MSDE service pack on this place.

  • Aha.......it's those little details that cause problems all the time.

    Glad you figured it out.

    -SQLBill

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

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