September 25, 2014 at 2:59 am
I'm trying to mirror a database to a secondary instance which is on the same domain.
I have alredy restored the database (In recovery...) on site B.
When I create the mirroring through the wizard I receive an error when I want to start the mirroring.
I then try to set the partner manually:
ALTER DATABASE MyDB
SET PARTNER = 'TCP://<hostname>:5023'
-- I replace <hostname> with the real hostname
The error I receive is:
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://........: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.
Has anybody come across this error?
September 25, 2014 at 4:00 am
do you have windows firewall enabled on the secondary server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:03 am
No, firewall is disabled on mirror site.
September 25, 2014 at 4:05 am
Can you telnet from the primary server to the secondary on the port specified?
September 25, 2014 at 4:14 am
oskargunn (9/25/2014)
No, firewall is disabled on mirror site.
ok what about a secondary firewall, as previously suggested attempt a telnet to the port from the principal server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:21 am
I've also tried to telnet from primary site to mirror site, and that works. That's why I'm completely baffled about this error :/
September 25, 2014 at 4:44 am
oskargunn (9/25/2014)
I've also tried to telnet from primary site to mirror site, and that works.
on what ports?
It will also help if you can confirm whether or not there are any firewall devices between the 2 endpoints
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:08 am
PRIMARY: 5100
MIRROR: 5101
tried to telnet from both sites and telnet works. (so, on primary i can telnet to mirror site through port 5101)
September 25, 2014 at 5:12 am
ok, the endpoint is using port 5023!!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:19 am
http://msdn.microsoft.com/en-us/library/cc646023.aspx
According to this article there is no default port for database mirroring. Mirroring has worked before, and then I've been using 5022 and 5023.
I just tried 5100 and 5101 to see if the port was the problem.
I dropped the endpoints and recreated them both again with port 5023, but I still get the same error.
September 25, 2014 at 5:19 am
Can you telnet to the server on port 5023?
September 25, 2014 at 7:52 am
Yes when I am positioned on the server and telnet to mirror site on port 5023, that works.
And I can also telnet from mirror site to the primary site on port 5023.
September 25, 2014 at 8:35 am
OK, next thing to check is that the account used for mirroring has permissions to connect to the endpoints.
September 25, 2014 at 8:39 am
Is there a good way to see if the user doesn't have these rights?
Because I did issue a grant permission on the endpoint to this particular domain user that I am using.
September 25, 2014 at 8:47 am
No there isnt a default port but the endpoint is set to 5023 so why are you telnetting to a different port?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply