SQL Server na Server Core

Instalace včetně GUI

Setup.exe /UIMODE=EnableUIOnServerCore /ACTION=INSTALL

Je potřeba nainstalovat i Client Connectivity

Pak z SQLCMD:

EXEC sys.sp_configure N'remote access', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

Povolit browser a spustit ho

sc config SQLBROWSER start= auto
net start SQLBROWSER

Povolit firewall

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

Napsat komentář