Identify 'sa' Usage Before Disabling 'sa'
-
I want to disable 'sa' and use a different account instead, and need to find where 'sa' is used.
I ran sp_who2. What are all these entries using 'sa' ?
- This topic was modified 8 months, 2 weeks ago by homebrew01.
-
Hi,
we got the same result with sp_who2, but our sa account is disabled.
I think, if you put the account to disabled, nobody is able to use this account for login.
The account is stil able to do the job on the sql server.
kind regards,
Andreas
-
Don't you monitor your connections (using XE) ?
"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply