Avatar of techmiss
techmiss
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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

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
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
techmiss

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DBAduck - Ben Miller

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
arnold

Can one ping the other?
Tracert is there a VPN between the sites?
What are the IPs?
Does each server instance run with the same domain account or does each use local account?
SOLUTION
Ramesh Babu Vavilla

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
techmiss

ASKER
Hi all,  thank you for your replies.

Network and DNS is fine between the two servers, they are both live machines (they are at different ends of my MPLS network).

Principal is on 10.7.100.3/24, Mirror is on 10.9.100.28/16 they can both reslove eachothers hostnames and FQDN

@dbaduck: I have run that query (thanks very useful) and I the information on both servers is the same, port 5022 with encryption enabled.


@sqlserver: I will read your blog now, thanks

K
techmiss

ASKER
Hi all, two problems I found.

1) The service accounts were actually running under different accounts (despite me thinking they weren't) - odd as this has not caused me an issue before.

2) I needed to restore some transaction logs to the end of the DB restore on the mirror else the prncipal threw an error.

Cheers

K
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck