Scripts para instalar SQL Server 2012 en Windows Server Core

Les comparto los comandos para instalar SQL Server 2012 en Windows Server Core 2012.




sconfig

tzutil /l
tzutil /s "Central America Standard Time"

netsh interface ip show config
netsh interface set interface name="Ethernet" newname="LAN"
netsh interface ip set address "LAN" static 192.168.210.9 255.255.255.0 192.168.200.200 1
netsh interface ip set dnsservers "LAN" static 192.168.210.200

hostname
netdom renamecomputer %COMPUTERNAME% /newname:CONTOSOCORE02
shutdown /r

netdom join CONTOSOCORE02 /domain:CONTOSO.local /userD:administrator /passwordD:P@ssw0rd
shutdown /r

--enable Remote Desktop

cscript C:\Windows\System32\Scregedit.wsf /ar 0
netsh advfirewall firewall set rule group="Remote Administration" new enable=Yes

-- remote shell
WinRM quickconfig

-- Add the .NET Framework 2.0 and 3.5
dism /online /enable-feature /all /featurename:NetFX3 /source:D:\sources\sxs
DISM.exe /online /enable-feature /featurename:MicrosoftWindowsPowerShell



-- insertar disco SQL Server Core
d:\setup.exe

setup.exe /UIMODE=EnableUIonServerCore


Setup.exe /QS /ACTION=Install /FEATURES=SQLENGINE,REPLICATION,CONN,IS /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=CONTOSO\SQLServer /SQLSVCPASSWORD=P@ssw0rd /SQLSYSADMINACCOUNTS=CONTOSO\Administrator /AGTSVCACCOUNT=CONTOSO\SQLServer /AGTSVCPASSWORD=P@ssw0rd /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS=1 /UPDATEENABLED=False

netsh firewall set portopening TCP 1433 "SQLServer"







Comments

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

Machine Learning Services con SQL Server Managed Instance

Demostración de SQL Server Query Store