September 27, 2022 at 11:05 am
So I have my own individual windows login to SQL & access via a group.
user1
dbaGroup
I want to delete the first and I'll then still have access via the latter. I can't delete because it says I'm already logged in. Is there a way of doing this myself? worst case I'll get another admin user but I'd rather just get it done.
September 27, 2022 at 11:18 am
you need to get another admin to do it - or you setup a SQL agent job to delete it for you (but will need to kill all sessions with your login in order to do it)
September 27, 2022 at 2:31 pm
Genius, I can do it via a job. Thanks! I'm the only real admin & talking anyone else through it will be a pain. Only issue now is that it's telling me the user owns databases & it doesn't.
September 29, 2022 at 5:08 am
Hi,
maybe you can use the sa user, only to kill your own admin account. After you removed your account, just disable the sa account for a better security.
kind regards,
Andreas
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply