Installing SQL 2012 on Windows Server 2008 Core
Been busy trying to work my way through the SQL 2012 training and I got to say, it hasn’t gone well. Let me start with what I am working with. I have an MacBook Pro with 8GB so first up I am not in a Windows environment. To follow the suggested practices in the Microsoft Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases. I have installed Virtual Box and installed 5 Windows Servers one of which is Windows Server Core. This server makes life interesting to say the least, the problem I have had is that the suggested command lines do not work? I do not now why, it is the way it is, below is the command line that I used.
d:\Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="mydomain\sqlsvc" /SQLSVCPASSWORD="P@s5w0rd" /SQLSYSADMINACCOUNTS="mydomain\sqlsysadmin" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS
I spent hours trying to get this to work, maybe I am missing something? I eventually moved forward by following Mitesh Chauhan’s tutorial and modifying configuration file to suit my requirements. I now have SQL 2012 installed on my virtual Windows core Server 2008 and working my way through the rest of the book.
To install Analysis Services from the command line we using the /FEATURES=AS option.
The /ASSERVERMODE can be set to MULTIDIMENSIONAL, TABULAR, or POWERPIVOT.
The below is an example of an install which I used on my Windows Server 2008 test machine.
d:\Setup.exe /qs /IAcceptSQLServerLicenseTerms /Action=install /Features=AS /ASSERVERMODE=TABULAR /INSTANCENAME=ASTabular /ASSVCACCOUNT=NetworkService /ASSYSADMINACCOUNTS=<myDomain\chosenUserAccount>
NOTE: Reporting Services which cannot be installed on Windows Server 2008 Core,