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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!