[case分享]在Azure IaaS VM搭建SQL AlwaysOn出現41131錯誤

標籤：azure;sql;always;on;41131;wsfc

Azure環境：1台 DC+2台SQL 2012(用庫中的SQL VM，不是VM自搭建SQL Server)

故障：

在AlwaysOn嚮導，出現這樣的錯誤資訊：

Failed to bring availability group ‘HADB‘ online.  The operation timed out. Verify that the local Windows Server Failover Clustering (WSFC) node is online. Then verify that the availability group resource exists in the WSFC cluster. If the problem persists, you might need to drop the availability group and create it again.

Failed to create availability group ‘HADB‘.  The operation encountered SQL Server error 41131 and has been rolled back.  Check the SQL Server error log for more details.  When the cause of the error has been resolved, retry CREATE AVAILABILITY GROUP command. (Microsoft SQL Server, Error: 41131)

解決方案：

1.建立NT AUTHORITY\SYSTEM帳號

USE [master]GOCREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master]GO

2.授權NT AUTHORITY\SYSTEM帳號

GRANT ALTER ANY AVAILABILITY GROUP TO [NT AUTHORITY\SYSTEM]GOGRANT CONNECT SQL TO [NT AUTHORITY\SYSTEM]GOGRANT VIEW SERVER STATE TO [NT AUTHORITY\SYSTEM]GO

PS:在IaaS VM部署alwayson注意哦，建立完群集後手動設定群集IP。

本文出自 “gs_hao” 部落格，謝絕轉載！

[case分享]在Azure IaaS VM搭建SQL AlwaysOn出現41131錯誤