August 22, 2011 at 1:00 pm
I thought I would post this in the hopes that it will be helpful to someone. This took place on a Windows 2008 R2 Enterprise Cluster.
I used Windows Update to update half of a two-node SQL Server Cluster. On the second node, Windows Update failed with 80070005. Posts indicated that this was an authorization or security related error. We tried all measures along these lines without results.
Then we noticed that Server Manager was not refreshing properly and tracked down a decent post with the following steps in it.
"To resolve it, please modify the Default Authentication level to “connect” and issue is resolved. Here are the steps to do that:
1) Type DCOMCNFG in start -> Run
2) Expand the Component Services -> Computers -> MyComputer.
3) Right click on the MyComputer and select properties.
4) Go to Default properties Tab and make sure that default authentication level is set to “Connect” and Default Impersonation level is set to “Identify”.
"
This resolved the issue for both Server Manager and Windows Update. Go figure. A DCOM default prevented Windows Update from running. Ouch.
Anyway, this is not currently documented in a KB article, so I thought it may be helpful for anyone with a similar issue.
August 25, 2011 at 2:30 am
I've made a note of this, thanks.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy