Post reply

Problem installing SP4 on MSDE 2000 (SP3)

  • June 26, 2007 at 1:14 am

    #372487

    Hi there,

    I have some big trouble installing SP4 onto an existing MSDE 2000 (with SP3).

    I run setup like described in the readme: "setup /upgradesp sqlrun" => Setup starts and I get: "Product already installed ... "

    Im using the MSDE version of the SP4 setup, the MSSQL version Im running is 8.00.760

    Ive also tried to use the UPGRADEUSER and UPGRADEPWD arguments, but with the same results.

    Any ideas?

    Thank you

  • June 26, 2007 at 1:36 am

    #715128

    Are yout trying to do it from GUI or the command line. If from GUI why do you specify the parameters. Then check if the server has anyother instances installed and if they have SP4 on it.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 26, 2007 at 1:42 am

    #715129

    Thanks for the fast reply!

    I try the installation from command line (what do you exactly mean with GUI?)

    The server only has one (the default) instance running, and doesnt have SP4 on it.

    If I query the version I get 8.00.760 (=SP3), SP4 would be 8.00.2039...

  • June 26, 2007 at 1:46 am

    #715130

    From the GUI i meant diuble click the exe that you have for your sql server SP4. it will take you up to a wizard and from there.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 26, 2007 at 2:05 am

    #715136

    Unfortunately the MSDE-Version of the setup doesnt have a GUI..

    If i start setup with no arguments or from explorer, I get: The instance name specified is invalid.

    I think this comes from the fact that if you start setup like the way above on a "empty" machine, it simply installs a default instance.

    You can specify another instance name in the setup.ini before you start setup without arguments, this way it installs the named instance

    I just discovered that setup upgrades my version successfully if i start it with "UPGRADE=1". The strange thing is that this parameter has to be used (according to the readme) in connection with an existing MSDE 1.0 version

    But Im sure i dont have a 1.0 version installed, its 2000 SP 3

  • June 26, 2007 at 3:17 am

    #715145

    ok looks like the UPGRADE=1 parameter isnt a solution for this problem

    After upgrading to SP4 using the parameter above, I cant connect to the MSSQL server

    I get a "connection refused".. ive also discovered that the mssql port (1433) is closed after the upgrade

  • June 26, 2007 at 3:33 am

    #715149

    Have you rebooted the server post SP4 installation.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 26, 2007 at 3:39 am

    #715151

    Yes, but it didnt change anything..

  • June 26, 2007 at 5:12 am

    #715175

    You have installed SP4 which requires a reboot. Ok now you give a static port for your sql server other than the default 1433 and check if you are able to make connections.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 26, 2007 at 5:17 am

    #715177

    I just got everything to work.

    The problem was that the SP4 setup deactivated all active protocols of the updated instance. I just reactivated "Named Pipes" and "TCP/IP", now everything works fine

    Anyways thanks alot for your effort Sugesh!

  • June 26, 2007 at 5:31 am

    #715183

    Good that you have atlast your sql running.BTW whenever you do a upgrade perform to check the protocols and connection information.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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