Jeffrey,

the 'drop' command fails.

Steve

Jeffrey,

Thank you for the list! Most interesting.

Question: What do you do when step 1 fails? (as it did, when I attempted to drop the servername)

Steve

Brian,

Point well taken. I can specify SQL Server authentication, but I still am coming up with '26' error messages, which I believe indicates that I am having problems connecting...

@ Jason A:

1. There is no AD. Two separate 'work groups'

2. The host files have been edited.

3. Ping resolves the name to the correct IP address,...

Perry,

Thank you! I am very interested in hearing how our engineering folk respond to this suggestion. But the bottom line is clear - the problem is in the...

Perry,

We're using Microsoft's VM.

Steve

Satish,

Most of the time the mirror works normally and the ping responds in minimum time value. It's an intermittent outage, which makes it very difficult to pin down. ...

One thing I didn't see stated in this thread: WHAT changes from hour to hour, day to day? If it is only the database content, then your recovery...

@Jeet - any resolution to your problem? I was struggling with the same issue, only within SQL Server 2008; I tried both windows authentication and SQL Server...

If you don't limit yourself to a defined query, you can try examining either the SQL Server logs or the System Application logs. Generally you will receive the same event...

@okbangas:

Agreed that virtually any compatible version of SQL Server can work as witness. Not sure about 'older' versions as witness, but as you observed, since you can...

I agree with you. What you describe is the correct way to do things.

I was trying to paint a non-SQL equivalent scenario, as a hypothetical, not...

okbangas and dev,

The mirroring is established between virtual servers. The question could be analogous to three physical servers, but two of the three servers share a single UPS. ...

Lynn,

Are you saying that, unless all three instances are taken down together, any two instances unavailable breaks the mirror and stops processing of client transactions?

I already identified in online resources...

Lynn Pettis (9/17/2011)

---

Is this single user id a windows login or a SQL login? If a SQL Login, the problem you are encountering is that the SID of the...