• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1219
  • Last Modified:

SQL Server 2008 Mirror (Witness issue Error 1456)


I have set up database mirroring before and know most of the gotchas with adding in a mirror, but I am really stuck on this new build.

Our setup is

3 physical boxes all with live IP and local lan.
Server A and Server B are domain controllers and the Witness is a member of the domain.

SQL and the agent runs as domain\administrator

We have mirroring working on Server A and B but without the Witness.

All servers through SSMS can connect to each other using the Windows AD login.

So, why is it when I add in the Witness do I get

TITLE: Microsoft SQL Server Management Studio

The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. (Microsoft SQL Server, Error: 1456)

On the witness

select * from sys.database_mirroring_endpoints

Mirroring      65536      261      2      TCP      4      DATABASE_MIRRORING      0      STARTED      0      2      WITNESS      1      3      NEGOTIATE      0      1      RC4

All servers have hosts / dns entries, nothing is connecting on IP.

So I am now very stuck and need to fix this quickly :(
  • 3
1 Solution
Do you have connect permission to anonymous on database?
Also, ensure that the port 5022 access is enabled through firewall.
andy_boothAuthor Commented:
Hi Sameer,

Do you have connect permission to anonymous on database? I am not sure what you mean by this, could you explain in more detail?

I can 100% confirm that I can telnet in all directions between the servers.
andy_boothAuthor Commented:
Well, I got it to work.

However I am not really too sure what fixed it, I rebooted all the servers and then the mirror broke.

So I stopped and started the end point on the mirror server and it all worked.

For reference, these are the commands

select * from sys.endpoints (to get the name of the end point)


andy_boothAuthor Commented:
fixed it myself
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
Tackle projects and never again get stuck behind a technical roadblock.
Join Now