Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

 

Windows Server Core: Microsoft Server has so many features which is not required on the server and would never been used, but it exists and sometime cause issue. For this reason Microsoft has introduced an operating system called “CORE” from “windows server 2008” has introduced “Windows Server 2008 Core”.

Server Core does not have any GUI In it, you have to use a command prompt to operate.

For more information http://technet.microsoft.com/en-us/library/dd184075.aspx

 

Sql server 2012 support this Server Core operating system, now you can install Denali on it using command prompt or configuration file.

 

Command prompt – Setup.exe options can be provided using below link:

 

http://msdn.microsoft.com/en-us/library/ms144259.aspx

 

Installation Features:

 

http://msdn.microsoft.com/en-us/library/hh231669(v=sql.110).aspx

 

Setup.exe /q /ACTION=INSTALL /FEATURES=SQLENGINE /SQLSVCACCOUNT=”<Domain\User>” /SQLSVCPASSWORD=”<Pwd>” /SQLSYSADMINACCOUNTS=”< Domain\User>” /AGTSVCACCOUNT=”< Domain\User >” /IAcceptSQLServerLicenceTerms

 

Server Core has its own limitation, as it is dedicated server with no GUI, we cannot work on the feature which requires gui, on sql server we have to use “POWERSHELL” to work on it. Or need to enable the remote access to use remote GUI(different server ) for SSMS requires TCP/IP enabled.

  • Can only be install on 64bit system (not supported for 32bit system)
  • Must provide unattented setup option with “/q or /qs” with “/IAcceptSQLServerLicenceTerms” option
  • Only “SQLENGINE, REPLICATION, FULLTEXT, AS, IS, CONN” features supported

 

 

Uninstall: Setup.exe /Q /Action=Uninstall /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER

 

 

Advertisements
This entry was posted in Denali, Installation and tagged . Bookmark the permalink.

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