I had sp3 fail on me today. Apparently I was supposed to pause mirroring and that is why it failed. Everything seems fine coming back up except I have a database now called temp_MS_Agent_signing_Certificate_database and when the instance restarted and also every instance has the error:
The SQL network interface library could not register the service principal name (spn) fo the sql server service (error 0x2098) - I am working in a domain for both client and server.
Do I really need to reinstall the instances?