Can you install 2000 SP4 on MSDE?

  • The MSDE version is SP3, not 3A, it's on a 2003 Standard Edition SP2 server. I try installing base SP4 and it says it can't find SQL Server 2000. We need to get SP4 installed on it so that Data Protection Manager will be happy. It isn't really critical as I have an autoexec SP that backs up the databases whenever someone connects to the database, and I have a scheduled job that runs at 23:00 that backs up the databases and does a DBCC. So not critical, but it would make my network admin happy.

    Any thoughts?

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • I believe this is what you are looking for:

    http://www.microsoft.com/download/en/details.aspx?id=18290

    About six down from the top is SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE download.

    Editor: Added hyperlink

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Yeah, I think that's it. Maybe I shouldn't try to download service packs late at night. 😀

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 3 posts - 1 through 3 (of 3 total)

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