Is Windows Server 2008 "Server Core" appropriate for a SQL Server instance?

Is Windows Server 2008 "Server Core" appropriate for a SQL Server instance?

"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?"

Asked by: Guest | Views: 437

Total answers/comments: 4

Comments display order:

Guest [Entry]

"Not sure how credible this source is, but:

The Windows Server 2008 Core edition can:

Run the file server role.
Run the Hyper-V virtualization server role.
Run the Directory Services role.
Run the DHCP server role.
Run the IIS Web server role.
Run the DNS server role.
Run Active Directory Lightweight Directory Services.
Run the print server role.

The Windows Server 2008 Core edition cannot:

Run a SQL Server.
Run an Exchange Server.
Run Internet Explorer.
Run Windows Explorer.
Host a remote desktop session.
Run MMC snap-in consoles locally."

Guest [Entry]

ASP.Net will be enabled on server core in R2.

Guest [Entry]

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.

Guest [Entry]

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.