Link to home
Create AccountLog in
Avatar of Gavin Tech
Gavin TechFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How can I identify where an AD account is being used in SQL including scripts?

An employee has suddenly left the firm and his AD account has been used in many sql scripts and within sql. How can I identify where an AD account is being used in SQL as I need to change the credentials in sql and any scripts before I disable the leaver account. Please can an expert help. 

Avatar of Gavin Tech
Gavin Tech
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thats fine. Thank you very much. 

Avatar of arnold
You just go and look at the jobs and who the owner is.

The other approach if deactivate the account, you look for failed login attempts using this user account and Look at the IP from which the request came.



How many sql servers do you have?

ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer