Solved

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

Posted on 2013-01-20
3
884 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 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql how to insert a column with the data  in an existing table 4 36
Search Text in Views 2 28
SonicWall port forward 4 28
Backup Options in vSphere 6.x 1 36
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

734 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