Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Database Mirroring issue

Hello,

When trying to do a database mirror, I get the attached error after I go through the wizard.  Note that during the wizard everything connects just fine between servers and I get the green checkmarks at the end of the wizard.  When I click start mirroring, the attached error comes up.

Any ideas?  Here is the sql statement I used to create the endpoints:


USE [master]

GO

CREATE ENDPOINT [Mirroring]

        AUTHORIZATION [domain\administrator]

        STATE=STARTED

        AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

        FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

, ENCRYPTION = REQUIRED ALGORITHM AES RC4)

GO


Thanks,DB Mirror Issue
0
soadmin
Asked:
soadmin
  • 3
  • 2
1 Solution
 
magarityCommented:
The mirror port 5022 is different from the basic connection port; I suggest checking the firewall rules both on the server and at the network switches as a first step.  The network switch port rules are a likely culprit.  You might have to ask for help from your network admin.
0
 
soadminAuthor Commented:
Hello,

I use port 1533 and have set everything correctly.  I can telnet to each server with port 5022, and 1533.  I cannot telnet to port 1434 however, even though I have put a firewall rule in place on the windows firewall.  Also, when I open up sql and do browse for more server and click on network servers, I do not see the mirror server from the principal and vice versa.  Could this be the problem?
0
 
magarityCommented:
Well, it's really hard to diagnose without being there but it does suspiciously sound like a case of a blocking rule somewhere. Have you checked the settings in the connection manager (under sql server > configuration tools from the start menu)?  Is your company big enough to have a dedicated networking admin and did you check with that person?  Network switch filewall and or port forwarding rules will frequently stop this kind of thing too.
0
 
soadminAuthor Commented:
Hello,

Yes, I forgot to mention that I did check with them and they said they are not blocking anything.  Could this be due to the size of the database?

What settings do I need to look at in connection manager?
0
 
magarityCommented:
Here's the mirror setup troubleshooting checklist on technet. Do the 6 items in the 'endpoints' section: http://technet.microsoft.com/en-us/library/ms189127.aspx#Endpoints
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now