2 added 40 characters in body; edited tags
source | link

I'm trying to setup Always OnAvailability groups for SQL Server with two nodes.

I have two SQL Servers inat two different co locations.

I ran through the failover cluster validation and everything looked good except that it complained about each node only having 1 pair of network interfaces.

I next ran through the wizard to create a cluster and now get the following errors.

"This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager."

"This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager."

I gowent to Failover Cluster Manager to try to bring it online and then get the following message.

"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

Any suggestions of what I need to do to bring this second node online so I can continue with configuring Always ON?

I'm trying to setup Always On for SQL Server with two nodes.

I have two SQL Servers in two different co locations.

I ran through the failover cluster validation and everything looked good except that it complained about each node only having 1 pair of network interfaces.

I next ran through the wizard to create a cluster and now get the following errors.

"This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager."

I go to Failover Cluster Manager to try to bring it online and then get the following message.

"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

Any suggestions of what I need to do to bring this second node online so I can continue with configuring Always ON?

I'm trying to setup Availability groups for SQL Server with two nodes.

I have two SQL Servers at two different locations.

I ran through the failover cluster validation and everything looked good except that it complained about each node only having 1 pair of network interfaces.

I next ran through the wizard to create a cluster and now get the following errors.

"This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager."

I went to Failover Cluster Manager to try to bring it online and then get the following message.

"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

Any suggestions of what I need to do to bring this second node online so I can continue with configuring Always ON?

1
source | link

Setting up Always On Availability Groups with Windows Server Failover Cluster

I'm trying to setup Always On for SQL Server with two nodes.

I have two SQL Servers in two different co locations.

I ran through the failover cluster validation and everything looked good except that it complained about each node only having 1 pair of network interfaces.

I next ran through the wizard to create a cluster and now get the following errors.

"This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager."

I go to Failover Cluster Manager to try to bring it online and then get the following message.

"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"

Any suggestions of what I need to do to bring this second node online so I can continue with configuring Always ON?