question

udhayand-8188 avatar image
0 Votes"
udhayand-8188 asked udhayand-8188 edited

SQL Server FCI installation failing

Hi ,

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

122968-sqlfci-error.png

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://docs.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.


sql-server-general
sqlfci-error.png (177.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.