0

I'm running two MS-SQL instances to create a mirrored-database environment, I have an instance in a Virtual Machine and another instance, alongside the witness, in the physical machine. I know this isn't the best configuration but this is for learning purposes only.

Now, when I try to mirror the database it gives me the following error this. All the settings came automatically from the Mirror Configuration Wizard so the Server SHOULD be visible, besides I can connect to it from the physical management studio, and I have create an Inbound Rule on the VM to allow all incoming connections on port 5022.

How can I fix this?

Improve this question

1 Answer 1

Reset to default
1

Are you using domain accounts for your SQL Server Service accounts? If not, what are you using? Local System? Are you using certificates?

This post is a good troubleshooter for some of the more common 1418 causes -

http://blogs.msdn.com/b/grahamk/archive/2008/12/08/database-mirroring-error-1418-troubleshooter.aspx

In that blog there are a few links in the assumptions section that may apply here with your configuration.

Improve this answer
6
  • I'm not using any domain... I am just on the same Workgroup (and Homegroup for what is worth) and I'm not implementing certificates...
    – PedroC88
    Mar 15, 2011 at 15:13
  • what account is running your SQL Server Service on each instance?
    – Mike Walsh
    Mar 15, 2011 at 15:18
  • System on all
    – PedroC88
    Mar 15, 2011 at 15:23
  • 2
    Change it to Network service to see what happens. You'll have to restart the instances to make this change.
    – Mike Walsh
    Mar 15, 2011 at 15:28
  • Got it... but my answer will have to wait till tonight when I get home :)
    – PedroC88
    Mar 15, 2011 at 15:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .