We help IT Professionals succeed at work.

SQL Server 2008 R2 Mirroring error

I am using the Wizard to create the mirroring. the error that I am getting is attached.

Thank you
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012

Commented:
the error that I am getting is attached.
Please try again.
CERTIFIED EXPERT
Top Expert 2012
Commented:
Have you gone through these steps:
Troubleshooting Database Mirroring Deployment
http://msdn.microsoft.com/en-us/library/ms189127.aspx

Author

Commented:
No, I have not gone through these steps. The database mirroring was working but I break it.  I have the users, port, endpoint, but I forgot to prepare the database for mirroring. When I break the mirroring, I tried to recreate it with out preparing. Let me try again.

Thank you
hey just check my blog. it helps you in mirroring

http://sqlservr.blog.com/category/high-availability/

check user credentials for altering the database

SELECT role_desc, state_desc FROM sys.database_mirroring_endpoints

Author

Commented:
THANK YOU GUYS, IT HELP'S

Explore More ContentExplore courses, solutions, and other research materials related to this topic.