Solved

Setup issues with mirroring (2008 r2)

Posted on 2013-01-24
4
246 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL DATEADD 10 88
Update one rows based on previous row 5 35
query output (script) from a stored procedure 4 50
Connect to SQL 2008 r2 server over the Internet 4 78
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

732 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