July 5, 2015 at 3:56 am
Hello all,
Iam geting the following error when creating a endpoint (that will be used for allwayson)
The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.
My physical network card is configured with:
10.9.255.170
and iam creating my endpoint with
10.9.255.82
The creation of endpoint is being done with;
CREATE ENDPOINT [Hadr_endpoint]
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (10.9.255.82)
FOR DATA_MIRRORING (ROLE = ALL, ENCRYPTION = REQUIRED ALGORITHM AES)
GO
IF (SELECT state FROM sys.endpoints WHERE name = N'Hadr_endpoint') <> 0
BEGIN
ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED
END
GO
use [master]
GO
GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [account]
GO
Can anyone help me with this?
Regards,
Arestas
July 5, 2015 at 2:26 pm
Anyone can help with this one?
Regards,
Arestas
July 6, 2015 at 3:43 am
Arestas (7/5/2015)
Hello all,Iam geting the following error when creating a endpoint (that will be used for allwayson)
The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.
My physical network card is configured with:
10.9.255.170
and iam creating my endpoint with
10.9.255.82
The creation of endpoint is being done with;
CREATE ENDPOINT [Hadr_endpoint]
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (10.9.255.82)
FOR DATA_MIRRORING (ROLE = ALL, ENCRYPTION = REQUIRED ALGORITHM AES)
GO
IF (SELECT state FROM sys.endpoints WHERE name = N'Hadr_endpoint') <> 0
BEGIN
ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED
END
GO
use [master]
GO
GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [account]
GO
Can anyone help me with this?
Regards,
Arestas
Have you bound 10.9.255.82 to the network card as a stacked IP address?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 4:06 am
Well, no.
Figured already that if i use the Ip of the networkcard (10.0.255.170) instead of a virtual ip (10.0.255.83) all work as a charm. Problem here is that i have 5 instances and i would like to one different ip for each instance.
Regards,
Arestas
July 6, 2015 at 4:11 am
Arestas (7/6/2015)
Well, no.Figured already that if i use the Ip of the networkcard (10.0.255.170) instead of a virtual ip (10.0.255.83) all work as a charm. Problem here is that i have 5 instances and i would like to one different ip for each instance.
Regards,
Arestas
Even if you do use multiple IPs, one for each instance, you'd still be binding them to the same physical NIC.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 4:12 am
Arestas (7/6/2015)
Well, no.
To use the IP you wanted to use you would need to add this to your NIC IP address list
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 4:15 am
So basically i ll need to add the 5 ip addresses to the nic that will be used for AO replication.
Well, tks for your help again mate.
Regards,
Arestas
July 6, 2015 at 10:14 am
yes, until the IP is bound to the adapter you cannot use it, but as I said you're still pushing all that traffic down the 1 NIC!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply