Troubleshoot

Case1:

Account For Which Logon Failed:
    Security ID:        NULL SID
    Account Name:        sqlservice
    Account Domain:        SCFULFIL01

Failure Information:
    Failure Reason:        The specified account's password has expired.
    Status:            0xc000006e
    Sub Status:        0xc0000071

把 Account 的 PW 設定成不會過期即可.

Case2: install on vm fail

在 failover cluster 上安裝時 "群集服務(MSCS)校驗錯誤"

並提示查找KB953748或SQL SERVER叢書解決，無法正常安裝SQL群集。

安裝第一個節點時

Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

安裝第二個節點時

Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode

Doc:

http://support.microsoft.com/kb/953748/en-us

Case3:

"Node and cluster edition match" fail

product key 問題

Case4:

Microsoft SQL Server, Error: 1326

MSSQL 的 TCP Port Setting 是會 sync 過去的, 不過 Server Setting 不會 !!

(Firewall 開 port)