| title | sp_denylogin (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | db80f152-e8af-4303-95b6-3a3a7b664374 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Prevents a Windows user or Windows group from connecting to an instance of [!INCLUDEssNoVersion].
Important
[!INCLUDEssNoteDepFutureAvoid] Use ALTER LOGIN instead.
Transact-SQL Syntax Conventions
sp_denylogin [ @loginame = ] 'login'
[ @loginame = ] 'login_ '
Is the name of a Windows user or group. login is sysname, with no default.
0 (success) or 1 (failure)
sp_denylogin denies CONNECT SQL permission to the server-level principal mapped to the specified Windows user or Windows group. If the server principal does not exist, it will be created. The new principal will be visible in the sys.server_principals (Transact-SQL) catalog view.
sp_denylogin cannot be executed within a user-defined transaction.
Requires membership in the sysadmin fixed server role.
The following example shows how to use sp_denylogin to prevent Windows user CORPORATE\GeorgeV from connecting to the server.
EXEC sp_denylogin 'CORPORATE\GeorgeV';
sp_grantlogin (Transact-SQL)
Security Stored Procedures (Transact-SQL)
ALTER LOGIN (Transact-SQL)
System Stored Procedures (Transact-SQL)