plc.myforum.ro

kosta · Member Joined: 09 Aug 2015 Posts: 161 Location: Salonic

Restricting logon to SQL Server
Mika Wendelius
Introduction
Sometimes you may need to restrict the user from logging into SQL Server. This can be done in several ways and this article discusses two main techniques:
Using a logon trigger
Using a database specific procedure to control login

The variations using logon trigger are typically used when the user authentication is done by the SQL Server. The procedural approach can be used in many kinds of situations even if the connecting login is always the same from SQL Server point of view. Of course these examples can be modified in several ways to achieve desired logic.

http://www.codeproject.com/Articles/1139017/Restricting-logon-to-SQL-Server