Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 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.

share|improve this answer
    
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 '11 at 15:13
    
what account is running your SQL Server Service on each instance? –  Mike Walsh Mar 15 '11 at 15:18
    
System on all –  PedroC88 Mar 15 '11 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 '11 at 15:28
    
Got it... but my answer will have to wait till tonight when I get home :) –  PedroC88 Mar 15 '11 at 15:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.