tool to scan for SA accounts in use across servers/database

Hello -

I'd like to know where on my servers and or databases that I can find the SA account in use. Is there a specific open source tool which I can utilize to scan and see where it is being used?
LVL 1
First LastAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
SA account exists in all SQL Server instances since it can't be deleted.
What it can be done is to disabled the user.
0
arnoldCommented:
Your best bet, is to use sql trace using sql server profiler during normal operating to capture a sample of data which you will then filter based on the LoginName. This will identify the database and the application that is the source of the connection.


Depending on your application is it plain text (ASP etc) where the connection string is not encrypted.

The trace will help you narrow down the applications to search through.
once you deal with that, you would need to rerun this process a few times to make sure you did not miss any that might not be normally in use.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.