• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 992
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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