July 3, 2023 at 5:50 am
I have enabled Server Auditing to the log the user connection. Everything is fine but It is logging only when we connect through SSMS. Many of the users will connect through .Net app and Python. The users with are connecting from coding, I cannot see them in the audit log.
I have configured the Audit using Successful_login_group. Any help can be very useful to me.
July 4, 2023 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 4, 2023 at 1:51 pm
Did you enable as well the "Server Audit" as well as the "Server Audit Specification" ?
Check filters !!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 5, 2023 at 4:46 am
Yes, It is enabled and logging the other users who are connecting from SSMS. There is an user which will connect SQL server from python program, but it is not logging into the Audit log file.
July 5, 2023 at 5:40 am
Please post the "Server Audit" and the "Server Audit Specification" scripts.
There must be some filtering active for it not to report all.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply