August 16, 2011 at 1:27 pm
I am trying to setup DB Mirroring, Primary and Mirror DB both on same server but diff instance with no witness server and encounter with below error.
Error:-
The server network address "TCP://....com:5023" 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.
I checked open ports on server
C:\WINDOWS>netstat -an|find/i "listening"
TCP 0.0.0.0:5022 0.0.0.0:0 LISTENING(Configured as Principal)
TCP 0.0.0.0:5023 0.0.0.0:0 LISTENING(Configured as Mirror)
I am not able to figure out what is wrong i m doing here..
Thanks in advance for your help..
August 16, 2011 at 4:09 pm
How are you configuring mirroring are you using scripts or the mirroring page on the database options?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:17 pm
I am using database mirroring page in GUI.
August 16, 2011 at 4:30 pm
Have you configured the security for the mirroring session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:31 pm
Have you configured the security for the mirroring session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 6:00 pm
I backed up db on principle server (Full and T-log) and restore in Mirrored db(same server but diff instance) with no recovery.
In Principle Server right click on DB>task>mirror> configured security( i already configured security) and when i select the Start mirroring then i got above listed error.
August 24, 2011 at 1:24 am
Trying using diffrent ports for the principal and the mirror.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
August 24, 2011 at 10:56 am
Jinu43 (8/16/2011)
configured security( i already configured security)
Sorry for the delay replying. I believe you may already have an endpoint configured on the mirror instance that is different to what you are specifying.
Is this the only database you are mirroring between these instances?
If so, login to SSMS on the principal and the mirror and under Server Objects > Endpoints > Database Mirroring delete each of the endpoints. Go back to the mirror page in the GUI and setup the security afresh and attempt to restart the mirroring
-----------------------------------------------------------------------------------------------------------
"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