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"
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