Errors while attempting the mirroring process in SQL Server 2005
0
Q:
Errors while attempting the mirroring process in SQL Server 2005
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
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
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
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