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

x
?
Solved

Setup issues with mirroring (2008 r2)

Posted on 2013-01-24
4
Medium Priority
?
253 Views
Last Modified: 2013-02-03
Hi
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.

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------

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?

Thanks
Sue
0
Comment
Question by:rdbconcepts
[X]
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
4 Comments
 
LVL 40

Expert Comment

by:lcohan
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?
0
 

Accepted Solution

by:
rdbconcepts earned 0 total points
ID: 38815252
Hi

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
Sue
0
 
LVL 40

Expert Comment

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

Author Closing Comment

by:rdbconcepts
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
0

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