Dedicated Administrator Connection in SQL Server

Dedicated Administrator Connection in SQL Server: "Enabling the Remote Dedicated Administrator Connection"

USE masterGOsp_configure 'show advanced options', '1'
GO
RECONFIGURE WITH OVERRIDE
GO
/* 0 = Allow Local Connection, 1 = Allow Remote Connections*/
sp_configure 'remote admin connections', '1'
GO
RECONFIGURE WITH OVERRIDE
GO

Comments

Popular posts from this blog

Manual de alarma Chevrolet

:-) Matematicas Puras Aplicadas

http://www.colombiasoyyo.org