Question

Error message during database mirroring on SQL Server 2005

Database mirroring, SQL Server 2005, SQL Server errors

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:

TCP://Joe:5024 principal
TCP://Joe:5025 mirror
TCP://Joe:1433 witness

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?

All three instances are hosted on the same machine, so the ALTER DATABASE command for each database should be the same, with only the port number being changed.