I would like to create a SQL Server 2005 user account but limit that user to only allow them to have two concurrent connections to the database at once. Is there any way to do this through SQL Server configuration?
Sql-server – Limit Concurrent Database Connections by SQL Server User Account
connectionssql serveruser-management
Related Topic
- Sql-server – SQL Server to SQL Server linked server setup
- Sql-server – Cross Database Permissions SQL Server
- SQL Server – How to Dump Database to SQL Script
- Sql-server – Fastest way to move a SQL Server database between systems and SQL Server versions
- Sql-server – Windows authentication in SQL Server allows user to see ANY database
Best Answer
You could try Login Triggers: http://technet.microsoft.com/en-us/library/bb326598.aspx
TechNet suggests that:
Their first code example limits a user to 3 connections (Quoting TechNet):