February 25, 2020 at 12:52 pm
Hi,
I am getting below error while installing SQL server, when selected domain account for SQL server engine startup account and press next.
(11) 2020-02-16 14:58:48 Slp: Sco: Attempting to check if container 'WinNT://DOMAIN' of user account exists
(11) 2020-02-16 14:58:48 Slp: Prompting user if they want to retry this action due to the following failure:
(11) 2020-02-16 14:58:48 Slp: ----------------------------------------
(11) 2020-02-16 14:58:48 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(11) 2020-02-16 14:58:48 Slp: Inner exceptions are being indented
(11) 2020-02-16 14:58:48 Slp:
(11) 2020-02-16 14:58:48 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
(11) 2020-02-16 14:58:48 Slp: Message:
(11) 2020-02-16 14:58:48 Slp: Access is denied.
(11) 2020-02-16 14:58:48 Slp:
(11) 2020-02-16 14:58:48 Slp: HResult : 0x84bb0001
(11) 2020-02-16 14:58:48 Slp: FacilityCode : 1211 (4bb)
(11) 2020-02-16 14:58:48 Slp: ErrorCode : 1 (0001)
(11) 2020-02-16 14:58:48 Slp: Data:
(11) 2020-02-16 14:58:48 Slp: WatsonData = Domain
(11) 2020-02-16 14:58:48 Slp: DisableRetry = true
(11) 2020-02-16 14:58:48 Slp: Inner exception type: System.UnauthorizedAccessException
(11) 2020-02-16 14:58:48 Slp: Message:
(11) 2020-02-16 14:58:48 Slp: Access is denied.
(11) 2020-02-16 14:58:48 Slp:
(11) 2020-02-16 14:58:48 Slp: HResult : 0x80070005
(11) 2020-02-16 14:58:48 Slp: Stack:
(11) 2020-02-16 14:58:48 Slp: at System.DirectoryServices.Interop.UnsafeNativeMethods.IAdsContainer.GetObject(String className, String relativeName)
(11) 2020-02-16 14:58:48 Slp: at System.DirectoryServices.DirectoryEntries.Find(String name, String schemaClassName)
(11) 2020-02-16 14:58:48 Slp: at Microsoft.SqlServer.Configuration.Sco.User.LookupADEntry()
I am installing SQL server 2016 STD version on Windows 2016 OS which joined to Domain controller.
Note: I can install by selecting Local System as startup account. later can change through configuration manager. I can't do this workaround for Cluster installation.
Any body faced this issue?
February 25, 2020 at 3:10 pm
Cross-post on DBA Stack Exchange
Have you tried the advice from the comments posted there?
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 25, 2020 at 4:01 pm
Hi ,
My issue is with Cluster installation where I must use Domain account for service start.
February 25, 2020 at 4:39 pm
Sometimes you can get around that error by running Setup.exe as Administrator - right click and select Run As Administrator.
Sue
February 25, 2020 at 4:55 pm
Thank you . I tried this option, no luck.
February 25, 2020 at 6:36 pm
From the error, it looks like in Active Directory the default Read permission for the Active Directory Users and Computers container has been changed. You may want to check that or have whoever manages AD check the permissions.
Sue
May 21, 2020 at 10:54 pm
Hi, Im facing the same issue. Verified that the installation user has read and list permissions to the AD. Have you resolved this issue?
Thanks
May 22, 2020 at 5:13 pm
This was removed by the editor as SPAM
July 4, 2020 at 1:22 pm
I had the same issue Winnt://Domain, Access is denied. The logs appeared to show that access was denied and couldn't even get as far as validating the service account. User account being used to install SQL was a domain account with membership of the local administrators group on the SQL server. Install allow to search AD and select the domain user account for the sqleng service but on clicking next would hang.
In my instance, checked our domain controllers and modified the domain controller policy for the following setting:
Network access: Restrict clients allowed to make remote calls to SAM
Added in user account performing the SQL Install or added in group of which that account has membership.
After that SQL install appeared to progress past the service accounts settings and completed the SQL install successfully.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply