Solved

SQL Server 2008 R2 Mirroring error

Posted on 2012-03-13
6
416 Views
Last Modified: 2012-03-26
I am using the Wizard to create the mirroring. the error that I am getting is attached.

Thank you
0
Comment
Question by:iscivanomar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37718051
the error that I am getting is attached.
Please try again.
0
 

Author Comment

by:iscivanomar
ID: 37722282
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 37722387
Have you gone through these steps:
Troubleshooting Database Mirroring Deployment
http://msdn.microsoft.com/en-us/library/ms189127.aspx
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:iscivanomar
ID: 37722506
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
0
 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 250 total points
ID: 37723492
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
0
 

Author Closing Comment

by:iscivanomar
ID: 37768748
THANK YOU GUYS, IT HELP'S
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question