Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmad.osama
Posting Yak Master
183 Posts |
 Posted - 2009-06-11 : 06:45:04
|
| Hey... I have many audit failure entries in application log"Login failed for user sa" client: xxx.xx.xx.xxxHow can i proceed to solve this issue.Regards,Ahmad Osama |
|
|
Brillix
Starting Member
3 Posts |
Posted - 2009-06-11 : 10:31:39
|
| You are getting this message because some one is trying to login as SA but he is using wrong password, this error can indicate that some one is trying to get into your database as SA or some one that have the permissions is trying to connect to the database but doesn't know the password.See [url]http://www.dbsnaps.com/articles/sql-server-login-audit/ [/url] for detailed information about login audit.Oded Razwww.dbsnaps.comwww.orbiumsoftware.com |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-13 : 06:24:48
|
quote:
Originally posted by Brillix
You are getting this message because some one is trying to login as SA but he is using wrong password, this error can indicate that some one is trying to get into your database as SA or some one that have the permissions is trying to connect to the database but doesn't know the password.See [url]http://www.dbsnaps.com/articles/sql-server-login-audit/ [/url] for detailed information about login audit.Oded Razwww.dbsnaps.comwww.orbiumsoftware.com
thanks for advertising the product....but I do know that some one is trying to login to sql server....I want to know that how can i track the machine whose IP address I haveRegards,Ahmad Osama |
|
|
|
|
|
|
Audit Failure.....