Windows Server 2012 Beta “Core” and SQL Server 2012


The quickest way to a failed installation of SQL Server 2012 is not to add the .NET 3.5 Framework feature and make sure you have your media or internet access for the server. 

Error installing .NET 3.5 on Windows 8 Server Beta

In the example below I have the ISO mounted in “D:”

dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:d:\sources\sxs /LimitAccess

dism.exe /online /enable-feature /featurename:NetFX3

or using PowerShell

Add-WindowsFeature –name NET-Framework-Core –source d:\sources\sxs

Add-WindowsFeature –name NET-Framework-Core

On Windows Core you cannot use the GUI to perform the install so here is an example command-line which I used to install SQL Server Database Engine, Full Text and Connectivity Components.

Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine,FullText,Conn
/INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="contoso\administrator" 
/TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS

SQL Server 2012 Setup Command Line

More information about the command line is located here.

SQL Server 2012 Setup Success

Don’t forget to open the Firewall ports for SQL Server on Windows Server

clip_image002[13]

The commands (No GUI under Windows Core, or you could enable Remote Management and do it remotely) required to do this are as follows:

  • netsh advfirewall firewall add rule name=”SQL Server Database Engine” protocol=TCP localport=1433 dir=in action=allow
  • netsh advfirewall firewall add rule name=”SQL Server Agent” protocol=TCP localport=1434 dir=in action=allow

About wesmacdonald

Wes MacDonald is a Visual Studio ALM MVP, PSD, MCT and a Principal Consultant for LIKE 10 INC., a SharePoint Server, Visual Studio and Team Foundation Server Consulting Firm providing premium support and guidance services.

No comments yet... Be the first to leave a reply!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: