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.


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 1
netsh interface ip set dnsservers "LAN" static

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

setup.exe /UIMODE=EnableUIonServerCore


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