|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Wednesday, November 25, 2009 9:14 AM
Points: 17,
Visits: 13
|
|
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
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 7:12 PM
Points: 3,082,
Visits: 12,545
|
|
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
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Wednesday, November 25, 2009 9:14 AM
Points: 17,
Visits: 13
|
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 7:12 PM
Points: 3,082,
Visits: 12,545
|
|
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
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, March 18, 2010 1:41 PM
Points: 1,016,
Visits: 3,759
|
|
| windows 2000 is out of support. windows 2003 is going end of mainstream support in 2010
|
|
|
|
