TITLE: Microsoft SQL Server Management
Studio
------------------------------
Create failed for Availability Group
'HDFASN_AG1'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL
statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot bring the Windows Server Failover
Clustering (WSFC) resource (ID 'c35dc1cc-34c3-4045-b323-93d4bf78f421') online
(Error code 5018). The WSFC service may
not be running or may not be accessible in its current state, or the WSFC
resource may not be in a state that could accept the request. For information about this error code, see
"System Error Codes" in the Windows Development documentation.
Failed to designate the local availability
replica of availability group 'HDFASN_AG1' as the primary replica. The operation encountered SQL Server error
41066 and has been terminated. Check the
preceding error and the SQL Server error log for more details about the error
and corrective actions.
Failed to create availability group
'HDFASN_AG1'. The operation encountered
SQL Server error 41160 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: 41066)
------------------------------
Resolution:
USE
[master]
GO
/****** Object: Login [NT AUTHORITY\SYSTEM] ******/
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
USE
[master]
GO
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GRANT ALTER ANY
AVAILABILITY GROUP
TO [NT AUTHORITY\SYSTEM]
GO
GRANT CONNECT SQL
TO [NT AUTHORITY\SYSTEM]
GO
GRANT VIEW SERVER
STATE TO [NT
AUTHORITY\SYSTEM]
GO
No comments:
Post a Comment