I need to deploy a new SQL Server 2005 database server this week using Windows Server 2008 as the operating system. My goal is to create the most minimal installation possible to reduce the attack surface and improve performance.
I’ve been looking at the Server Core installation option which seems perfect for this purpose since it removes the GUI and many unnecessary components. However, I’m uncertain whether SQL Server database engine can actually run on Server Core.
I’ve checked Microsoft’s documentation about Server Core compatibility but couldn’t find specific information about SQL Server support. Has anyone successfully installed and run SQL Server on Server Core? Are there any limitations or issues I should be aware of before proceeding with this approach?
curious about your timing here - are you locked into sql server 2005 specifically? since you’re already going with 2008 server, wouldn’t sql 2008 give you more options? also wondering if you’ve considered running sql on a vm instead for better isolation?
SQL Server 2005 cannot be installed on Windows Server 2008 Server Core. Microsoft explicitly excluded SQL Server from the supported applications list for the initial Server Core release. The primary limitation stems from SQL Server’s dependency on various GUI components and services that Server Core removes by design. I encountered this same restriction during a similar deployment project. The workaround involved using the full Windows Server 2008 installation and manually disabling unnecessary services post-installation to achieve a more secure footprint. Alternatively, consider SQL Server 2008 Express which has better compatibility with minimal installations, though it comes with its own feature limitations. For your security and performance goals, focus on hardening the full installation through Windows features removal and service configuration rather than attempting Server Core compatibility.
yeah, sql server 2005 just dosn’t run on server core. i tried it before and the installer fails since it relies on gui stuff that’s missing. best option is to go with the full version and then secure it later with group policies and configs.