This is a really weird one, I'll try and explain as best I can!
Scenario(names are not the real ones BTW) -
RES - resource domain
AD - active directory
A server in the RES domain has sql server running under an account RES\SQL.
I connect to it with my own account which is in the AD and has full admin
access.
Fine so far, now I'll set a database to simple recovery mode. This works
fine and we continue as normal. Then I discover that during this process an
account in the active directory called AD\SQL has now been locked out!
I cant for the life of me see how this is happening with such a mundane task.
Any ideas?
Thanks, Mike
Thanks.
Uri Dimant - 26 Nov 2006 09:33 GMT
Mike
Can you run SQL Server Profiler to see what is going on?
> This is a really weird one, I'll try and explain as best I can!
>
[quoted text clipped - 19 lines]
> Thanks, Mike
> Thanks.