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.
Re: sql2005/linked server+imperonate ... When you go from the first SQL Server to the second SQL ...Active Directory attempts to use Kerberos as the authentication method first. ... so through delegation, but you have to do some setup. ... (microsoft.public.de.sqlserver)
Re: Querying Windows Active Directory from Sql Server 2000 ... is added to the active directory and i've rights in active directory to ... account in SQL Server to run the query. ... have permission to read the ActiveDirectory tree. ... OLE DB provider 'ADSDSOObject' reported an error. ... (comp.databases.ms-sqlserver)
Re: SMS Component errors after installing SP2 ... MVP Windows Server System - SMS... MP encountered an error when connecting to SQL Server.... If using a standard SQL security account,... is used to publish fully qualified host names in Active Directory.... (microsoft.public.sms.setup)
Re: Email unkown when trying to add user in AD mode ... The problem is that I can't add them as a user in Active Directory mode.... Wayne Snyder, MCDBA, SQL Server MVP... > SharePoint Services).... >> community of SQL Server professionals.... (microsoft.public.sharepoint.windowsservices)
