Reputation
544
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 28
Impact
~61k people reached

  • 0 posts edited
  • 0 helpful flags
  • 65 votes cast
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
Dec
5
comment Cannot add witness to my mirroring setup
@Ben: I successfully telnetted from the principal into the witness on the port of the mirroring endpoint. There is obviously no firewall problem.
Dec
3
comment Cannot add witness to my mirroring setup
@Ben: I had the same thoughts, but as already mentioned the firewall is currently switched off on the witness. And there are no outgoing port restrictions on the principal server.
Dec
3
asked Cannot add witness to my mirroring setup
Nov
3
awarded  Notable Question
Oct
28
comment How to enable encrypted connections to a SQL Server instance?
Actually you can activate the "force encryption" setting on the server without a trusted certificate, and it will always encrypt incoming connections. The only thing you cannot do in this scenario is activate the "encrypt connection" parameter on the client, because then it will complain about a non-trusted certificate. But that's only relevant for safeguarding against man in the middle attacks, not for making sure that people in your LAN cannot eavesdrop your SQL Server password.
Sep
29
awarded  Yearling
Aug
1
accepted How can I create a database backup replacing the previously created backup file?
Aug
1
asked How can I create a database backup replacing the previously created backup file?
Jul
9
awarded  Popular Question
Jun
23
comment What's the risk of running a Domain Controller so that it is accessible from the internet?
@Doc: Thanks for the advice. I definitely agree with the hint on ports. It helped me reduce the amount of brute force attacks on ssh on my linux servers a lot.