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 |
|
eashoori
Starting Member
22 Posts |
 Posted - 2009-01-30 : 12:53:53
|
| Our server (virtual) got rebooted yesterday and since then the following message pops up, this is a trusted account however it still gives us this message and has had sql errorlog huge, how cna I rectify it? Shall I ask the AD team to give admin access on the box to this particular box? Tnhkas for any infoLogin succeeded for user 'sa'. Connection: Non-Trusted. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 13:18:43
|
| Have you enabled Failed and Successful Login in Server Properties? |
 |
|
|
eashoori
Starting Member
22 Posts |
Posted - 2009-01-30 : 13:57:42
|
| Where should I check it? On SQl side or event viewer side? I am not an admin on this box but i cna ask admins to do itThanks for any info |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 14:00:12
|
| In Server Properties-Security. |
|
|
|
eashoori
Starting Member
22 Posts |
Posted - 2009-01-30 : 14:02:51
|
| and this should be enabed or disabledthanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 14:04:06
|
| Usually only Failed Login should be enabled unless you are doing Audit for all login. |
|
|
|
eashoori
Starting Member
22 Posts |
Posted - 2009-01-30 : 16:38:56
|
| If it was already disabled, is there any other way to stop the login logs?thank you |
|
|
|
|
|
|
Login succeeded for user 'sa'. Connection: Non-