Controlling Access Permissions

An important task in endpoint management is the granting, revoking, and denying of endpoint permissions. To control whether a login may connect to (and thus consume) an endpoint, you use the following syntax:


For example, to give a login called MyDomain\MyUserName connect permission on your endpoint, you would use this statement:


Note that whenever the login specified in the AUTHORIZATION keyword of the endpoint DDL isn’t the same as the login consuming the service, you must grant connect permission to that login. ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.