SQL Server FCI installation failing

Question

SQL Server FCI installation failing

udhayan d 181

Hi ,

I am installing SQL FCI on 2 node WSFC and getting below error

Looking at the cluster logs, i can see below error. I am not sure about what user name/password the setup is validating.
Because of restrictions in my org, we have prestaged the SQL Network Name (SQL2016FCI) and the Cluster has full control over prestaged SQL2016FCI object in AD.
FYI.. I am logged in as a local admin on the node.
https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc731002(v=ws.10)?redirectedfrom=MSDN

Cluster network name resource 'SQL Network Name (SQL2016FCI)' cannot be brought online. Attempt to locate a writeable domain controller (in domain unspecified domain) in order to create or update a computer object associated with the resource failed for the following reason:
The user name or password is incorrect.
.
The error code was '1326'. Ensure that a writeable domain controller is accessible to this node within the configured domain. Also ensure that the DNS server is running in order to resolve the name of the domain controller.

AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff

2021-08-20T09:41:23.237+00:00

Hi udhayand-8188,

How are things going on?
Did the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia
udhayan d 181 Reputation points

2021-08-20T10:27:30.557+00:00

Hi @AmeliaGu-MSFT ,

Yes cluster.log certainly had some additional information. These hosts were migrated from one domain to another domain in the past and the setup is trying to authenticate against the old DC. Looking deeper, the cluster still resolves to old DNS. Its clear that the domain migration was incomplete, so we are now in the process of setting up the cluster first before attempting SQL Cluster build. I will keep this thread posted about my progress.

Thanks for your help.

1 answer

Your answer

AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff

2021-08-20T09:41:23.237+00:00

Hi udhayand-8188,

How are things going on?
Did the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia
udhayan d 181 Reputation points

2021-08-20T10:27:30.557+00:00

Hi @AmeliaGu-MSFT ,

Yes cluster.log certainly had some additional information. These hosts were migrated from one domain to another domain in the past and the setup is trying to authenticate against the old DC. Looking deeper, the cluster still resolves to old DNS. Its clear that the domain migration was incomplete, so we are now in the process of setting up the cluster first before attempting SQL Cluster build. I will keep this thread posted about my progress.

Thanks for your help.

Answer 1

Hi udhayand-8188,

Could you please check if there are any error message in the cluster.log? Please refer to this article to get cluster.log.

The user name or password is incorrect.
The error code was '1326'

Have you changed the password before installing SQL Server cluster? Please check Error 1326 when you change domain account password in Windows which might help.

Best Regards,
Amelia

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

SQL Server FCI installation failing

1 answer

Your answer