Post reply

Does Win2003 works with SQL 2000 SP3 ?

  • September 19, 2006 at 9:38 am

    #62277

    I have SQL 2000 SP3 on a Windows 2000 Advanced Server SP4 and would like to upgrade to Windows 2003 Advanced Server (Win2003). Does Win2003 works with SQL 2000 SP3 ? Please help.

    Thanks, Jimmy

  • September 19, 2006 at 9:59 am

    #661302

    It is not called advanced server, it is enterprise edition and yep it works, remember to install SQL Server first before the service packs and there is also a 3a both are needed to run most .NET related applications.  The key is ignore all Windows questions answer only those relevant to you.  The service packs 3 and 3a are 25 .sql files Windows use as needed.  Hope this helps.

    Kind regards,
    Gift Peddie

  • September 19, 2006 at 10:30 am

    #661305

    Thanks Gift Peddie.

    I don't quite understand when you say "intall SQL Server first before the service packs". The server is already SQL 2000 SP3, my question was if I can upgrade the same box to Win2003 ?

    Another question: Isn't SQL 2000 SP3 the same as SP3a ? I always thought they are the same. Was there a SP3a release ?

    Thanks again, Jimmy

  • September 19, 2006 at 11:15 am

    #661313

    That is an upgrade of the OS don't much about that but I think you need to run some tests of the upgrade and fresh install then backup and restore your databases it will be clean. 

    And yes there was 3a without the a reporting services will not let you install it I learned the hard way.  And I cannot remember now but I opened the stuff so I have the 25 .sql files I can flip them to you and don't worry Windows use them as needed because I watched the install with all current OS and Windows use them from 11 to 14 files. 

    So try upgrade in a sand box and fresh install also in a sand box so there are no surprises.  Hope this helps.

    Kind regards,
    Gift Peddie

  • September 19, 2006 at 12:50 pm

    #661334

    Thanks a lot !

Viewing 5 posts - 1 through 4 (of 4 total)

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