• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 645
  • Last Modified:

How to check if "sa" account is being used to access databases in MS SQL 2005

Hi, could someone please advise if there is an easy way to check if any applications etc are using the "sa" account?  I don't know the sa password and need to check if there will be implications if I change it.  Failing that perhaps there is way to retrieve it without changing it?
Thank you!
0
support_ferret
Asked:
support_ferret
1 Solution
 
Sarika30Commented:
0
 
RiteshShahCommented:
if you have administrator login (windows authentication), you can login with that and reset SA password.

You can run profiler and see which application is using SA user

0
 
cyberkiwiCommented:
Hi there,

This is the SQL Server 2005 using SERVER-wide trigger

http://www.mssqltips.com/tip.asp?tip=1627
0
 
support_ferretAuthor Commented:
thank you for quick responses!  Sarika30 was first however with the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now