Mirroring - fully qualified domain name 1

[micang]

SQL 2005

Hi All,

I have 2 servers each located on differnt locations.

They both are not on a domain and they both connect to the net via a std router. Each server has a static IP.

I am trying to set-up mirroring on a very small db. I run through the mirroring wizard, all seems fine, but the servers cannot connect when I actually try to activate mirroring. (The servers connect to each other via SSMS etc no problem). I have also opened the relevant ports for the mirroring and configured the firewall.

I think the problem is the fully qualified domain name(FQDM) - I am struggling to know what it is, if the server is not part of a domain.

Currently I am tring: TCP://ipaddress(100.200. etc)ort number. Reading up it says the FQDM should include a hostname, but what is this if the server is not on a domain?

Any help towards the correct direction will be appreciated.

Thank you.

Michael

 

[mrdenny]

You can use an IP Adress to connect. If you want to use the domain name simply setup DNS for each server.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[micang]

Hi Denny,

Thank you for the reply.

That's the weird thing, I can connect via ip address into each server from anywhere, using SSMS, QA etc, but when I use the same IP for mirroring, it does not connect and to add to the confusion, if I telnet to teh port I have set up for mirroring, it connects.

So I am really confused why for mirroring the ip adress is not working.

I appreciate your input.

Michael

 

[mrdenny]

When you setup the endpoints for database mirroring did you specify that the endpoint should be used for database mirroring?

What's the exact error you are getting?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[micang]

Hi Denny,

Your're right, it was the end points. I was getting error 1418 - either db does not exist or etc etc.

There was an "anonymous" account, I grant that rights, and the mirro now synchronises.

Thank you for confirming early on that the IP address is fine to connect, so I knew it must be something else.

Thank you again for your time.

Michael

 

[mrdenny]

No problem. Happy to help.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog