Post reply

Windows 2000 Advanced Server (SP4) or Windows XP

  • November 20, 2009 at 3:00 pm

    #216979

    Hey there,

    Before I begin, let me provide some background in that I work for a company that primarily has not upgraded from using SQL 2000 running on a Windows 2000 AS platform because it does not want to have to pay the licensing fees for the upgraded, full version OS and SQL Server softwares.

    That being said, I want to try to upgrade to either SQL 2005 or 2008 Express. Before I do that, though, can someone tell me if it's a better idea to install it on a Windows 2000 AS machine or a Windows XP Professional machine? Also, any information as to why one choice is better than the other would be greatly appreciated! 🙂

    Thanks for your help,

    Kevin

  • November 20, 2009 at 3:24 pm

    #1082530

    Kevin Rodgers (11/20/2009)

    Hey there,

    Before I begin, let me provide some background in that I work for a company that primarily has not upgraded from using SQL 2000 running on a Windows 2000 AS platform because it does not want to have to pay the licensing fees for the upgraded, full version OS and SQL Server softwares.

    That being said, I want to try to upgrade to either SQL 2005 or 2008 Express. Before I do that, though, can someone tell me if it's a better idea to install it on a Windows 2000 AS machine or a Windows XP Professional machine? Also, any information as to why one choice is better than the other would be greatly appreciated! 🙂

    Thanks for your help,

    Kevin

    SQL Server 2008 will not run in Windows 2000 because it is .NET 3.5 dependent so it cannot be installed in Windows 2000. So install many 2005 in the Win2k and install a few 2008 in XP because XP will not use more than 4gig of ram which allows you only four.

    Kind regards,
    Gift Peddie

  • November 23, 2009 at 8:30 am

    #1082969

    Thanks for the input. 🙂

  • November 23, 2009 at 11:10 am

    #1083068

    Kevin Rodgers (11/23/2009)

    Thanks for the input. 🙂

    I am glad I could help, you know your employer could buy the Win2003 Small business server from third party or buy the Win2008 Small business server it comes with SQL Server Standard edition for 75 concurrent users. This comes with the operating system and many other Microsoft servers including SQL Server Standard. This is another option if your employer choose to spend some money.

    Kind regards,
    Gift Peddie

  • November 25, 2009 at 9:05 am

    #1084133

    windows 2000 is out of support. windows 2003 is going end of mainstream support in 2010

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

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