August 15, 2011 at 12:17 pm
Hi,
I have a machine with two NIC one will be used for SQL server communication for application to use and other for dedicated database mirroring traffic
I am using the following to create end point to use a dedicated IP on Principal/Mirror servers (the below command is for the principal, the same command with different IP will be used for Mirror)
On Principal:
IF NOT EXISTS (SELECT 1 FROM SYS.database_mirroring_endpoints)
BEGIN
CREATE ENDPOINT [DATABASEMIRRORING]
STATE= STARTED
AS TCP(LISTENER_PORT=5022,LISTENER_IP=('10.10.10.87'))
FOR DATABASE_MIRRORING(ROLE =ALL)
END
But is it throwing the below error:
Msg 7888, Level 16, State 1, Line 5
The IPv6 address specified is not supported. The server may not be configured to allow for IPv6 connectivity, or the address may not be in a recognized IPv6 format.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '10.10.10.87'.
On Mirror:
IF NOT EXISTS (SELECT 1 FROM SYS.database_mirroring_endpoints)
BEGIN
CREATE ENDPOINT [DATABASEMIRRORING]
STATE= STARTED
AS TCP(LISTENER_PORT=5022,LISTENER_IP=('10.10.10.86'))
FOR DATABASE_MIRRORING(ROLE =ALL)
END
But is it throwing the below error:
Msg 7888, Level 16, State 1, Line 5
The IPv6 address specified is not supported. The server may not be configured to allow for IPv6 connectivity, or the address may not be in a recognized IPv6 format.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '10.10.10.86'.
Can somebody help me to the steps & syntax for assigning a dedicated IP for mirroring?
Thanks
August 15, 2011 at 2:15 pm
check which TCP protocols you have bound to the NICs, you will need IPV4
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:50 am
I have additional 10 GB NICs on each node of the mirror...
On the principal I used the following to create the end point:
CREATE ENDPOINT [DB_Mirror]
AUTHORIZATION [Domain\UserName]
STATE=STARTED
AS TCP (LISTENER_PORT = 5030, LISTENER_IP = (192.168.XXX.X))
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
GO
GRANT CONNECT ON ENDPOINT::DB_Mirror TO [domain\sqlserverService account]
------------
Created the end point on the mirror node...
CREATE ENDPOINT [DB_Mirror]
AUTHORIZATION [Domain\UserName]
STATE=STARTED
AS TCP (LISTENER_PORT = 5030, LISTENER_IP = (192.168.XXX.Y))
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
GO
GRANT CONNECT ON ENDPOINT::DB_Mirror TO [domain\sqlserverService account]
If you want the entire document, let me know.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply