Click here to Skip to main content
11,929,232 members (60,246 online)
Rate this:
Please Sign up or sign in to vote.

How can i get the login attempt in sql server.
I am working in Naviosion 2009r2 (my new company have Navision ,actuality I am a C#.Net developer ) and it is using Sql Server as database.Maximum number of users allowed in Navision is 54 (Actually Navision is using sql users for login), so when 55th user trying to login ,it blocks the new user with a message . So i need to write a trigger ,which executes when the user try to log in ,and in the trigger if some user idle time is grater than a specific time (say 1 hour ) then the idle user need to disconnect , so new user is allowed to login .

Posted 20-Aug-14 2:22am
Edited 28-Aug-14 0:07am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Aadyakumar 20-Aug-14 7:39am
This is something different,failed login attempt coming after login attempt . but how can i trigger an event when some one attempting for login
Uma Shankar Patel 20-Aug-14 7:49am
I think you can use Logon Trigger

Some help can be get from

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.1 | Last Updated 28 Aug 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100