GilaMonster (7/31/2008)
A quick guess - have you removed Builtin\Administrators from the allowed logins? If so, put it back, make it sysadmin and try the patch again.No promises. That security patch breaks in a thousand ways and has twice as many fixes.
Hi Gila,
Well here is the funny thing...I haven't removed anything on this particular server...the BuiltIn\Administrators is still present...
And I had read a lot of posts regarding that very question.
At first I didn't give it much thought and attempted to re-run the patch...it failed.
I know the sa account for the server so I decided to download the patch and attempt to install manually.
When I ran the patch and it asks for verification (Windows vs. SQL)
I entered the sa password I know works as I tested it in Q.A. and it gives an error saying something like "one or more instances cannot verify your account..."
SO...it basically only allows for Windows auth...
The account that I logged into the server initally wasn't set up as a sysadmin so I logged out and relogged in with the account that is running the services which IS a sysadmin on the server...
Re-ran the patch, and used Windows Auth...
Gets to the point in the patch execution where it says "spawning instances" and it hangs and does nothing, no progress...
Then fails with some cryptic error message and requires a reboot...
For this particular server I am on MSSQL 2000 - 8.00.2039