I'm setting up a dedicated SQL Server 2005 box on Windows Server 2008 this week, and would like to pare it down to be as barebones as possible while still being fully functional.
To that end, the "Server Core" option sounds appealing, but I'm not clear about whether or not I can run SQL Server on that SKU. Several services are addressed on the Microsoft website, but I don't see any indication about SQL Server.
Does anyone know definitively?
Not sure how credible this source is, but:
ASP.Net will be enabled on server core in R2.
Server Core 2008 R2 can run Sql Server, but this is unsupported (for now). Check http://www.nullsession.com/2009/06/02/sql-server-2008-on-server-core-2008-r2/ for an article + video on how it's done.
No. For some things, you will need the
.net
Framework (like reporting services), and you can't install it (in a supported way) in a server core.Server Core won't be very useful (to me at least, and I think many others as well) until they get a version of .Net framework on it. Maybe a specialized subset like they have in the Compact Framework on smart phones.
Following are new features for Server 2008 R2 Server Core:
.NET Framework – 2.0, 3.0, 3.5.1, 4.0 are now supported on Server Core installation
ASP.NET – as .NET is now supported on Server Core R2 ASP.NET can be enabled
PowerShell
AD CS – AD Certificate Services role can be installed on Server Core R2 system