Home > IT Answers > Database > Error message during database mirroring on SQ...
SQL Server Ask the Experts
2435 pts.
0
Q:
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?
ASKED: Sep 2 2008  5:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Sep 2 2008  9:36 PM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   47070 pts.  |   Sep 2 2008  9:36PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0