Alwayson - access Point for administering?

Question

Post reply

Alwayson - access Point for administering?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
October 5, 2015 at 10:59 pm

#321165

Node 1 -IP Address 10.xx.xxx.11
Node 2 -IP Address 10.xx.xxx.12
while create cluster wizard in access Point for administering the cluster which
IP address need to type Address filed? Does it Node1 IP to be type?
1. I have type Node 1 -IP Address 10.xx.xxx.11 in that filed but I Received error as below
You do not have permissions to create a computer object in the Active Directory
2. What type of permission is required that particular domain id which was logged both the nodes?
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

Firstly, read my stairway to Alwayson starting at this link

http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]

SQL Galaxy (10/5/2015)
Node 1 -IP Address 10.xx.xxx.11
Node 2 -IP Address 10.xx.xxx.12
while create cluster wizard in access Point for administering the cluster which
IP address need to type Address filed? Does it Node1 IP to be type?
1. I have type Node 1 -IP Address 10.xx.xxx.11 in that filed but I Received error as below

You need a separate unique IP address for the cluster access point. It's all detailed in my stairway

SQL Galaxy (10/5/2015)
You do not have permissions to create a computer object in the Active Directory
2. What type of permission is required that particular domain id which was logged both the nodes?
Thanks

Again check my stairway, there is also a link to an MS article detailing all of this

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

Thank you Mr. Perry for your wonderful article.. I will ask question if any doubts...

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?

2. My requirement is - one of the OLTP database to be configure Local site HA and DR setups (remote site),

So I am planning to configure and using HA feature of AlwaysOn in SQL 2012..

3. Remote site setup is different subnet with same domain (same domain group Local Node & Remote Node)..

How will applications to be connect and shared cluster resource with different subnet if primary node failed?

Could you suggest me which is best option to be choose for achieving those setups?

Thanks

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

SQL Galaxy (10/6/2015)
1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?

Yes, you can use standalone sql instances with local disks.

SQL Galaxy (10/6/2015)
2. My requirement is - one of the OLTP database to be configure Local site HA and DR setups (remote site),
So I am planning to configure and using HA feature of AlwaysOn in SQL 2012..

An AlwaysOn availability group would be a good choice

SQL Galaxy (10/6/2015)
3. Remote site setup is different subnet with same domain (same domain group Local Node & Remote Node)..
How will applications to be connect and shared cluster resource with different subnet if primary node failed?
Could you suggest me which is best option to be choose for achieving those setups?
Thanks

Windows 2012 and SQL Server 2012 -> support multiple subnets. The subnet address for each site is added as a resource to the AO cluster role. You'll likely need to enlist the help of your network admins to get the DNS entries configured and also the networking too.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 5

Thanks Perrry for your replay...

Can always On setup by using standalone SQL instance with local HD, In this scenario, Does it require to meets pre -requisites on both the nodes? as below.

1. Networking side..

To Uncheck the Register this connections addresses in DNS.

2. Ports details:

Cluster ServiceUDP3343

Cluster ServiceTCP3343 (This port is required during a node join operation.)

RPCTCP135

Cluster AdministratorUDP137

Randomly allocated high UDP ports UDP Random port number between 1024 and 65535

Random port number between 49152 and 65535²

3. Access Point for administering the cluster - which was rising first post.

Does application and interfaces are connected to the unique IP address(virtual IP)? am I correct? Pl. give the example or URL appl.connection string which is give to the application team to using new string once setup is done.

Thanks

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

I'm sorry its not clear what you're asking?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 7

Hello Mr. Perry..

What I am asking,

1. I should enter the unique IP address in access point administration portion while creating cluster group.

Application connection string which IP address to be follow? Is it Node1&2 Physical IP or unique IP?

2. In General scenario cluster group setup application to connect unique IP address only(that is virtual IP).

How does application to connect in alwayson AG? is there any modification required in connection string(web.config file)?

Thanks.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

SQL Galaxy (10/8/2015)
Hello Mr. Perry..
What I am asking,
1. I should enter the unique IP address in access point administration portion while creating cluster group.

Yes when creating the windows server failover cluster it will prompt for Client access point details (unique name and unique IP)

SQL Galaxy (10/8/2015)
Application connection string which IP address to be follow? Is it Node1&2 Physical IP or unique IP?

Your application will use the IP address of the clustered instance not the cluster access point or the node IP.

If you haven't already, please read my stairway to HA on this site starting at this link

http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]

SQL Galaxy (10/8/2015)
2. In General scenario cluster group setup application to connect unique IP address only(that is virtual IP).
How does application to connect in alwayson AG? is there any modification required in connection string(web.config file)?
Thanks.

In an alwayson group you can connect individually to each instance or employ a listener, the listener will require another unique IP address and network name. It's all in my guide 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉