Big day today. Just taken delivery of a new server box, dual core with 8Gb and Raid-1. By the cringe, it was a heavy beastie.
I will be installing Windows 2008 and SQL Server 2008 on it, as I intend to do some more heavy duty BI (still using Excel to be the presentation layer of course). In due course, I will add Sharepoint, and do some Excel Services (but let’s walk first).
I am not really a hardware or OS guy, in the past I have always had team mates who did that sort of thing, so this will be a new experience. Sort of looking forward to out, but I am worried it will take up more time than I can afford at present.
Let’s see how it goes.
Hey Bob,
If you wanted to take an easier route first and see how it all fits together, MSFT released a Virtual PC vhd to illustrate the full BI platform…The image includes SQL Server 2005 SP2 including SSIS, SSAS and SSRS, Office 2007, Sharepoint Server 2007 and PerformancePoint Server 2007 all running on Windows Server 2003 R2.
The Virtual PC is also a Domain Controller so Active Directory is loaded along with components like DNS, IIS and ASP.NET.
It’s not recommended to load all these server roles onto one machine like this, but it does work, if slowly.
I believe there is a newer version due out which will (i’m told) include SQL 2008 and associated upgrades – I guess you’d be able to throw the Office 2010 beta bits at it as well…Due in Q4 2009 i believe, if you want to wait a bit…
Hi Will,
Interesting. Will it run under 2008 (I would have thought so)?
At present I am struggling to get an OS on there. After multiple attempts, I finaly managed to download Windows 2008 ISO, but when I burn it, using Active@ ISO Burner, the installation rejected it as invalid. If I tried ISO recorder that said my media was unusable. What gives? I don’t know yet.
Hi Bob,
Sorry… been a bit busy…
Yes… the above stuff will run on Server 2008 and with SQL 2008 but there is not yet a packaged build, so you will be installing piece by piece i’m afraid… still, maybe that’s what you wanted to do anyway 😉