• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

Checking sybase login failure

One of users complaining his not able to login, how do I check > is there any error msgs being logged if failed login occured ?
0
motioneye
Asked:
motioneye
  • 3
2 Solutions
 
Joe WoodhousePrincipal ConsultantCommented:
Which Sybase product and version?

By default no messages are logged in ASE, ASA or IQ.

You *can* setup (assuming Sybase ASE) auditing, and then audit all login attempts.

Or you can have this user forward you the error message they get. :)

Also have a look at their login using "sp_displaylogin" because that will show you if their account is currently locked.
0
 
Joe WoodhousePrincipal ConsultantCommented:
Also, depending on your ASE version, you may be able to use this:

   sp_configure "log audit logon failure", 1
   go
0
 
motioneyeAuthor Commented:
Thanks Joe :)
You are only expert in Sybase in this forum ....
0
 
Joe WoodhousePrincipal ConsultantCommented:
motioneye, now that's just not true, we have many fine people helping out here! I think my timezone and sleep patterns let me answer sooner maybe. :)
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now