Wednesday, September 12, 2012

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"







No comments:

SQL Server 2016 Stretch Databases

El SQL Server Stretch Database permite que los datos históricos o de bitácoras puedan ser movidos hacia Azure, específicamente permite mover...