troubleshooting Question

SQL Mirroring - Not Working - Spot the Flaw...

Avatar of techmiss
techmissFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2008
5 Comments2 Solutions426 ViewsLast Modified:
Hi all,

I have configured several SQL boxes and  SQL mirroring scenarios but this one has me going round in circles.

The result I get is that the principal cannot talk to the mirror and gives the error TCP://MYSERVER.DOMAIN.LOCAL:5022 cannot be contacted when trying to start mirroring from SQL management studio.

Both servers are Win Server 2008 R2 running MS SQL 2008 R2 on VM Ware ESXi 4.1, as separate entities the servers are running without issue - both the OS and SQL installations are patched to the same level, the servers are on the same domain but different subnets and different AD sites.

On both servers the SQL server instance is running as the same user with domain admin privs.

To configure mirroring I have:

1) backed up and restored the relevant database to the mirror with no recovery
2) Configured security on the prinicpal with NO witness
3) Left the ports for both servers on 5022 (this is what SQL management studio had as default)
4) use the same account that SQL is currently running as for the mirroring service accounts.

Windows Firewall is off on both machines, there are not other firewalls inbetween the two devices, DNS resolves both FQDN and hostname.

When I try to start mirroring the principal cannot contact the mirror.. I'm sure I have missed something...

Help!

Cheers

K
ASKER CERTIFIED SOLUTION
DBAduck - Ben Miller
SQL Server Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros