I need to deploy a SQL Server 2005 instance on Windows Server 2008 and want to use the most minimal installation possible.
I’m considering the Server Core installation option since it should provide better performance and security with fewer components. However, I’m uncertain if SQL Server is compatible with this stripped-down version of Windows Server.
The Microsoft documentation covers various services that work with Server Core, but doesn’t specifically mention 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?
Any definitive information would be greatly appreciated before I proceed with the installation.
interesting question! why sql server 2005 specifically? that’s pretty outdated - microsoft dropped support years ago. have you looked at newer versions? they’d have much better server core compatibility. what’s your planned workload?
Nope, SQL Server 2005 won’t install on Windows Server 2008 Server Core. I’ve tried this myself on legacy deployments and it just won’t work. The problem is SQL Server 2005 needs GUI components that Server Core doesn’t have - no Windows Shell, no IE engine, none of the GUI frameworks the installer and Management Studio need. The setup will fail because it can’t find the graphical components. You’ll need the full Windows Server 2008 install if you’re stuck with SQL Server 2005. But heads up - mainstream support for SQL Server 2005 ended in 2011, so you’re looking at serious security and compliance risks in production.
sql server 2005 def won’t work on server core, it needs gui stuff. try sql server 2008 r2 at least, but it’s still a bit tricky. honestly, just go for full windows if you’re set on 2005. core’s perf boost ain’t worth the trouble.