Have a bit of a problem.
In deploying a Virtual Machine from a template, a duplicate name was created on the network and our WSUS server computer account got blown away. The WSUS server was then rejoined to the domain, but now gets errors that it cannot connect to the SQL server where the WSUS database lives. We would think this is due to the User account in the SQL database called domain\Computername$ having an incorrect SID.
Is there a way to either fix this in SQL by repairing or recreating the account, or get the WSUS console to cooperate in some other way?