[case分享]在Azure IaaS VM搭建SQL AlwaysOn出现41131错误
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
GO
CREATE LOGIN FROM WINDOWS WITH DEFAULT_DATABASE=
GO
2.授权NT AUTHORITY\SYSTEM账号GRANT ALTER ANY AVAILABILITY GROUP TO
GO
GRANT CONNECT SQL TO
GO
GRANT VIEW SERVER STATE TO
GO
PS:在IaaS VM部署alwayson注意哦，创建完群集后手动配置群集IP。
页:
[1]