June 4, 2003 at 1:53 am
Hi!
A guy, who left before me, had many trusted and sql logins on many servers (all MSSQL200 sp3) What steps should I take (before removing his logins) to make shure that this will not affect any jobs, replications, backups, etc... What is the fastest way to do this?
Thanx
June 4, 2003 at 9:11 am
If there is so many things to consider, just change the pwd of the login. It is always easy to manage to run all your jobs or any thing with a GENERIC ID instead of user login
Edited by - Shas3 on 06/04/2003 09:11:54 AM
Shas3
June 4, 2003 at 9:25 am
search sp_help_revlogin on technet. use this to script out the logins. Then change pwds and if you want, delete 1 a week after trying to find where they are used. it is a slow process, and something you want to move conservatively on.
Steve Jones
June 5, 2003 at 5:57 am
There are also trusted logins, that were deleted from the domain a week ago. Can I delete them without caution?
June 5, 2003 at 8:25 am
Yes, you can delete NT Authentication logins that have been deleted from the domain, because even if they were recreated in the domain, they would have different spid and so would not be recognized by SQL server anyway.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply