514 reputation
1924
bio website devermind.com
location Germany
age 38
visits member for 5 years, 3 months
seen Aug 25 at 9:36
Please visit my development blog at http://devermind.com if you'd like to learn more about me.

Sep
2
awarded  Notable Question
Jul
9
awarded  Popular Question
Jul
2
awarded  Popular Question
Apr
8
awarded  Popular Question
Mar
2
awarded  Popular Question
Feb
17
awarded  Nice Question
Dec
29
accepted Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
29
answered Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
12
comment Cannot add witness to my mirroring setup
The next line after the one you quoted restarts the mirroring session.
Dec
10
comment Cannot add witness to my mirroring setup
I think you are confusing this with the "alter database <dbname> set partner <hostname>" command. That one has to be executed on the mirror first, then on the principle. "Set witness" is only initiated on the principal - if you try to run it on the mirror, you get the following error: "Msg 1470, Level 16, State 2, Line 1 The alter database for this partner config values may only be initiated on the current principal server for database MYDBNAME"
Dec
10
comment Cannot add witness to my mirroring setup
I think the reason I did not get any monitoring data from the witness is that it raises less events than the principal and the event types are different as well. Please see my edit 3 above.
Dec
10
revised Cannot add witness to my mirroring setup
added 1151 characters in body
Dec
10
revised Cannot add witness to my mirroring setup
added 822 characters in body
Dec
10
revised Cannot add witness to my mirroring setup
added 42 characters in body
Dec
9
comment 10 servers to administer and I'm a history major
I'd like to express my sincere sympathy by upvoting this posting.
Dec
9
comment Cannot add witness to my mirroring setup
Thanks for the suggestion. I could not find the "Audit Database Mirroring Login" event (which event section is it? I searched all of "Security Audit", but it wasn't there). I added the results to my post above.
Dec
9
revised Cannot add witness to my mirroring setup
added 3569 characters in body
Dec
9
comment Cannot add witness to my mirroring setup
It's a name and I have triple-checked all three names can be resolved properly (via DNS) from all three hosts.
Dec
9
comment Cannot add witness to my mirroring setup
Yes, the witness endpoint is started. I am not using windows domains at all, but certificate-based authentication. Please see my OP for details.
Dec
6
revised Cannot add witness to my mirroring setup
added t-sql log