ok the certificate is or at least should be bound to the fully qualified computername which you have changed. Self certs do also seem to be an issue i have...

This will work

exec sp_configure 'show advanced options', '1'

reconfigure with override

exec sp_configure 'xp_cmdshell', '1'

reconfigure with override

set nocount on

create table #services(stext varchar(128))

insert into #services

exec xp_cmdshell "net start"

If (select * from #services where...

change the IP address on the server network connections centre and restart the sql server instance. Dont touch anything else!

is there a firewall between the 2 endpoints?

can the client machine resolve the server name or even ping it?

you also need to remove the passive node from the possible owners list on the cluster resources in case Murphy's law tries to fail over to that node during the...

where did you get the SSL certificate for the site, is it self generated?

patch the passive node first, remove the node from the possible owners list on the cluster resources. Install the SP. Add the node back to possible owners list afterwards.

Once done...

Sorry for the delay replying. I believe you may already have an endpoint configured on the mirror instance that is different to what you...

Follow my 3 part guide on this site starting at...

take a look at this article

A mirror database will only be read mode if you use database snapshots and...

Lowell (8/23/2011)

---

i don't think the collation is going to affect you at all, you should use the default server collation, you just have to use nvarchar columns everywhere instead of...

It's consistent, i'll give it that. It's the same in SQL Server 2008 R2 management studio 😀

i see what is confusing the OP now

go into the shrink file dialog and select the log file and release ununsed space, then script action to new query window. It...

good catch Gail i totally missed that bit 🙂