Errors while attempting the mirroring process in SQL Server 2005
Home > IT Answers > Storage > Errors while attempting the mirroring process...
SQL Server Ask the Experts
2445 pts.
0
Q:
Errors while attempting the mirroring process in SQL Server 2005
Mirroring, SQL Server 2005, SQL Server errors, SQL Server Enterprise Edition
I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages:

“Alter failed for Database 'db_muthu'. (Microsoft.SqlServer.Smo)”

“An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)”

“Database Mirroring Transport is disabled in the endpoint configuration. (Microsoft SQL Server, Error: 1486)”

What can I do to solve this issue?
ASKED: Sep 9 2008  7:33 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I believe that you need to simply enable the endpoint using the ALTER ENDPOINT command. You can find the name of the endpoint in the sys.endpoints DMV.

ALTER ENDPOINT YourEndpoint
 WITH STATE = STARTED
Last Answered: Sep 10 2008  3:28 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

Mrdenny   46795 pts.  |   Sep 10 2008  3:28AM GMT

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

 
0