One of the new features in SQL Server Denali CTP3 is support for installation on Server Core. There’s an MSDN article on “Installing SQL Server Denali on Server Core” and another MSDN article on “Install SQL Server Denali from the Command Prompt” that has a detailed list of all the different parameters.
Based on the first article, the setup routine should enable and/or install all of the necessary prerequisites, but that simply isn’t the case from what I found.
If you just run setup from the command prompt, you’ll end up with this message, although this is to be expected since there are some required parameters which must be specified at the command line or in a configuration file.
If you specify all of the correct parameters, the command will return to the command prompt without error after a few seconds and nothing related to SQL will be installed.
Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=
"mikefrobbins\sqlSvcAcct" /SQLSVCPASSWORD="password" /AGTSVCACCOUNT="mikefrobbins\sqlAgentAcct"
/AGTSVCPASSWORD="password" /AGTSVCSTARTUPTYPE="Automatic" /SQLSYSADMINACCOUNTS=
Go ahead and start Powershell and import the Server Manager module:
Enable the wow64-netfx3 feature:
Since there’s no GUI for this on server core, you’ll need to use the netsh command:
netsh advfirewall firewall add rule name="SQL Server Windows NT - 64 Bit" dir=in action=allow program="C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" enable=yes profile=domain
There’s no way that I’m aware of to run SQL Server Configuration Manager on server core or to run it remotely so you’ll have to manually edit the registry to enable TCP/IP. Run regedit, navigate to HKLM>SoftwareMicrosoft>Microsoft SQL Server>MSSQL11.MSSQLSERVER>MSSQLServer>SuperSocketNetLib>Tcp and set the value of enabled to 1:
You should now be able to use SQL Server Management Studio on a remote machine to access this SQL Server. If the connection fails, you can test connectivity from the remote machine by telneting to port 1433 on the sql server.