December 10, 2015 at 1:51 pm
HI All,
I am trying to configure database mirroring from SQL 2008 R2 enterprise edition as principle server and SQL 2012 developer edition as Mirror instance. Also i have already configured SQL AG always on successfully working on SQL 2012 instance for few other databases.
So now i have a requirement to configure the database mirroring and during which i am encountering this error message on SQL 2008 R2 instance.
Also when i see the endpoint on 2012 instance it is "Hadr_endpoint" on port 5022 which was already existed on 2012 instance and created /started during SQL AG setup. So i have a question that can i setup SQL AG and db mirroring on the same sql server? Also did any one encountered this below error? All the permissions are granted and also i can telnet servername 5022 also.. Please help.
command executed on Principle isntance SQL 2008 R2:
USE master
GO
ALTER DATABASE TestMirrorDB SET PARTNER = 'TCP://ABCinc.local:5022';
GO
Error Message:
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://ABCinc.local:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.
Also this error in windows event viewer logs:
Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no compatible authentication protocol. State 21
December 17, 2015 at 6:17 am
if TCP port 5022 is already used by the endpoint on the sql 2012 instance you'll need to select another TCP port that's not in use for the sql 2008 instances endpoint to use
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply