Menu
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?
899
You can install SQL Server on a Server Core installation. The Server Core installation option provides a minimal environment for running specific server roles. This helps to reduce maintenance and management requirements and the attack surface for those server roles.
Server Core is a minimal server installation option for the Windows Server 2008 R2 operating system. Server Core provides a low-maintenance server environment with limited functionality.
Extended Support Dates in Effect Windows Server 2008/2008 R2 and SQL Server 2008/2008 R2 have both met their end-of-life dates: July 9, 2019 for SQL Server 2008/2008 R2 and January 14, 2020 for Windows Server 2008/2008.
Summary: It worked, but it is not officially supported by Microsoft. That said, SQL Server 2008 can host databases running in 80 and 90 compatibility level, so you can use SQL Server 2008 as an intermediary between SQL Server 2000 and SQL Server 2019. This is not supported for production.
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.
195
ASP.Net will be enabled on server core in R2.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
