?
Solved

SQL 2012 database mirroring with auto failover  on vmware fails (error1418)

Posted on 2013-01-20
3
Medium Priority
?
897 Views
Last Modified: 2013-01-24
Hi guys.
trust you are well.

Im having an issue with sql 2012 mirrored synchronous config.
ive installed 3 SQL 2012 instances.
- expected solution - mirrored db with no SPOF running on VM's.
sql1 - hosting live DB
sql2 - Witness
sql3- Partner mirrored DB.

I have ran all configs according to best practices -
-  backup main db and transaction log,
-  restore sql1 db to sql 2(mirror) in NOREVCOVERY mode, as needed. restore transaction log in NORECOVERY as well. database is left at restoring mode....
now the mirroring should take place,
   - here I get the 1418 error, after configuring mirror, partner and witness on ports 5022 which is ok, and we can telnet each other as well - hence the 1418 error is addressing something else, dns is located on the subnet and serving machines, ports are open, no Local FW is running besides a small mcaffee agent which isnt bothering the connection as it seems.

any replies would be gladly accepted.

thanks
0
Comment
Question by:IT_Group1
[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
3 Comments
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 38799713
Clarifying questions:
All instances are on separate machines?
The mirror db was restored to sql 3 and not sql 2 in your example (since it is supposed to be the witness)
You right clicked on the database on sql1 and chose Properties and then Mirroring and filled out all the information and clicked start mirroring and that is when you got the error?
0
 
LVL 79

Assisted Solution

by:arnold
arnold earned 500 total points
ID: 38799749
Along the line of questions by dbaduck, does the status of the databse ever reflect that it is principal?

You may have to go through setting up log shipping and then configure mirror, after a first log ship push.
0
 

Author Closing Comment

by:IT_Group1
ID: 38817627
Thx guys.
basically it was the transaction log which held me back, post restoring it and leaving in NORECOVERY mode, running the mirroring post configuring domain users to run the app -
all went flawless

thx 4 ur time !
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

719 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