SQL Server 2014 deployment from SCCM task Sequence
Question
Hi,
does anyone knows if it is possible to some how preinstall SQL Server 2014 to Windows 10, so it is preinstalled but not configured? And when needed, it is fast to configure and take it into use. Also it is needed to be installed via SCCM Task Sequence to a machine which is not in domain.
Answer ( 1 )
Application deployment to non-domain joined /Workgroup devices are very limited.
But you can create an application in SCCM with SQL binaries but it won’t that easy process because you might need to provide answer files etc.. something like
Setup.exe /ConfigurationFile=ConfigurationFile.ini
Also, you can’t install the SQL enterprise version on Windows 10 devices
https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15#operating-system-support