I changed the service account my SQL server ran under and got this error on sharepoint after doing so. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0) After reading a lot of blogs and KB’s I finally found the fix. Add the service account to the local administrators group on the SQL server running […]
Read More →Archive for August, 2012
SQL Mirroring with SQL 2008 R2 principal/mirror + SQL 2012 Witness
Some quick notes on setting up mirroring with a 2012 witness. This is another lab experiment, but I ran into some silly mistakes. For posterity, here are mah notes.(I’m going to assume you understand mirroring and generally how to set it up). Make sure the service account you are using has connect granted to it […]
Read More →What uptime really means
Wondering about the SLA being offered by your host/provider. Here is what it means in daily, monthly, and annual downtime.?5 9’s looks near impossible doesn’t it? Some servers take longer than that to reboot so a standby is required to?achieve?that and you have to fail over to it prior to rebooting anything. On top of […]
Read More →