question

HRugbeer avatar image
HRugbeer asked

Limit number of connections to a database on a specific Login

I have a specific Login that I want to limit the numbers of connections to my database for a specific SQL login. How do I achieve this?
t-sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
If you are using a connection pool within an application then you can limit it that way, or us a Logon trigger within SQL Server ([2005 SP2 +][1]). See this [link][2] for the syntax [1]: http://technet.microsoft.com/en-us/library/cc917696.aspx [2]: http://msdn.microsoft.com/en-us/library/bb326598.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.