Solved

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

Posted on 2013-01-20
3
882 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
3 Comments
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 250 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 78

Assisted Solution

by:arnold
arnold earned 250 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

685 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