SQL Server AlwaysOn errors (Windows messages obtained through helpmsg”) “net If database has FILESTREAM/FileTable, then check if 8dot3 name creation is enabled for applicable drive(s). If it is enabled, disable it. The requested operation not be completed due DOS command1: fsutil 8dot3name query C: 665 to a file system limitation DOS command2: fsutil 8dot3name set C: 1 Checked if IP is already in use. May require a new/unused IP depending on what is being done. Check permission for cluster network object CNO. 5057 The cluster IP address is already in use. for additional messages in logs. Depending on the resource type, this generally requires involvement of Windows team. For multi-subnet cluster, check the HostRecordTTL property for network name. If it’s set to 1200 (20 minutes), suggested value is 300 (5 minutes). Try to remove SQL from this issue. For example, if this is a network name or an IP address resource, then try creating a Client Access Point with same name and IP if possible, and see it comes online. If The resource failed to come online due to the failure it does not come online, then this requires 5942 of one or more provider resources. investigation by Windows team. net helpmsg 8557 says "Your computer could not be joined to the domain. You have exceeded the maximum number of computer accounts you are allowed to create in this domain. Contact your system administrator to have this limit reset or increased." Your computer could not be joined to the domain. You For example, when a listener is created, a have exceeded the maximum number of computer Computer Object is automatically created in Active accounts you are allowed to create in this domain. Directory. Even Listener is dropped, that Contact your system administrator to have this limit Computer Object may remain in Active Directory. 8557 reset or increased. The other thing to know is that by default,
SQL Server AlwaysOn errors (Windows messages obtained through “net helpmsg”) 665 The requested operation not be completed due to a file system limitation If database has FILESTREAM/FileTable, then check if 8dot3 name creation is enabled for applicable drive(s). If it is enabled, disable it. DOS command1: fsutil 8dot3name query C: DOS command2: fsutil 8dot3name set C: 1 5057 The cluster IP address is already in use. Checked if IP is already in use. May require a new/unused IP depending on what is being done. Check permission for cluster network object CNO. 5942 The resource failed to come online due to the failure of one or more provider resources. for additional messages in logs. Depending on the resource type, this generally requires involvement of Windows team. For multi-subnet cluster, check the HostRecordTTL property for network name. If it’s set to 1200 (20 minutes), suggested value is 300 (5 minutes). Try to remove SQL from this issue. For example, if this is a network name or an IP address resource, then try creating a Client Access Point with same name and IP if possible, and see it comes online. If it does not come online, then this requires investigation by Windows team. 8557 Your computer could not be joined to the domain. You have exceeded the maximum number of computer accounts you are allowed to create in this domain. Contact your system administrator to have this limit reset or increased. net helpmsg 8557 says "Your computer could not be joined to the domain. You have exceeded the maximum number of computer accounts you are allowed to create in this domain. Contact your system administrator to have this limit reset or increased." For example, when a listener is created, a Computer Object is automatically created in Active Directory. Even Listener is dropped, that Computer Object may remain in Active Directory. The other thing to know is that by default,
troubleshooting-sql-server-alwayson-20130921.docx