Installing SQL Server Denali CTP3 on Server Core

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.

Go ahead and start Powershell and import the Server Manager module:

Enable the wow64-netfx3 feature:

This will actually enable the following features:

Type exit from within PowerShell to get back to a normal command prompt and then run setup again with all of the necessary parameters. The installation should begin:

The GUI portion of setup will begin, although it is unattended.

When the installation completes, you’ll be back at the command prompt:

Add a firewall exception for SQL Server:

Since there’s no GUI for this on server core, you’ll need to use the netsh command:

Enable TCP/IP in SQL Server Configuration Manager:

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:

Restart the SQL Server service:

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.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: