Hi Steve,

I've set the SQL Server on the witness to run as the local sysadmin account just for testing purposes. The windows sysadmin is also the sysadmin for the database,...

Thanks for the hint. I tried this, but for some reason I can't seem to see any mirroring-related login / logout events in my profiler. I can see other login...

Steve Turner - SQL Managed (12/6/2011)

---

Sorry if this seems obvious, but is your witness server configured for "SQL Server and Windows authentication mode" or just "Windows authentication mode"?

And do you...

Perry Whittle (12/6/2011)

---

so how come your script above references server1.ourdomain.com and server2.ourdomain.com

If setting up mirrroring in a workgroup please see the following...

Here's a complete log of the t-sql commands I used for setting up mirroring:

-- PRINCIPAL

create master key encryption by password = 'mypassword';

GO

create certificate "server1.ourdomain.com_cert" with subject = 'server1.ourdomain.com certificate', start_date...

Perry Whittle (12/6/2011)

---

adrian-844207 (12/3/2011)

---

Where are you executing this command from?

Have you double checked the steps to create the certificate and the user?

What value are...

Steve Turner - SQL Managed (12/5/2011)

---

I think the two likeliest causes are the witness server can't communicate back to the principle server or the authentication isn't working. If you...

PaulB,

Worked like a charm and exactly what I was looking for. Thanks very much! 😀

Adrian

Bitbucket,

Thanks for your reply, but I am not quite so sure that this is the same problem. They seem to have problems attaching a database, whereas I can attach it...