I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network addresses are:
If I attempt to run ALTER DATABASE newdotlearn SET Partner = 'TCP://DOTMIRROR1.joe.com:5024' from the mirror, it works. When I run ALTER DATABASE newdotlearn SET Partner = 'TCP://DOTMIRROR2.joe.com:5025' from the principal, I get the error. Do you know why?