up vote 0 down vote favorite
1
share [g+] share [fb]

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?

link|improve this question
feedback

1 Answer

up vote 1 down vote

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.

link|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
show 1 more comment
feedback

Your Answer

 
or
required, but never shown
discard

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