Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Setup issues with mirroring (2008 r2)

Posted on 2013-01-24
Medium Priority
Last Modified: 2013-02-03
I am trying to set up high performance mirroring between a primary server (ps1) and a secondary server (ss1)

When i tell the mirroring to start, the following error appears;

TITLE: Database Properties

An error occurred while starting mirroring.


Alter failed for Database 'Sue_Test'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The server network address "TCP://<SS1<.<domain>.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. (Microsoft SQL Server, Error: 1418)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476



I have checked that the ports are enabled, checked that I can see the SS1 from PS1 and have checked that the account that starts the services on each side has permissions.

Please can anyone advise me what else I need to do?

Question by:rdbconcepts
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 40

Expert Comment

ID: 38815236
What type of Authentication are you using? Are you using Windows authentication or SQL authentication for the mirroring endpoint?
How did you set it up - using the wizzard?

Accepted Solution

rdbconcepts earned 0 total points
ID: 38815252

I have literally just managed to get it to work :-)

Turned out that the account running the services didnt have the right permissions on the instances.

Dopey mistake not to have already checked - I was so busy checking that I had the correct user named that I didnt think about the actual permissions assigned!

Thanks lots though
LVL 40

Expert Comment

ID: 38815325
No problem - glad you make it work...

Author Closing Comment

ID: 38848286
Ive accepted my own solution simply because I worked it out before I was given the answer - it was just permissions that I hadnt thought to check

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question