Elegant Software Solutions' Blogs: Tom Hundley

KB948109 Security Hotfix Fails

Jul 12

Written by: Thomas Hundley
7/12/2008 9:19 PM

A security update from MS broke the production server for the first time in who knows how long. The automatic installation of the hotfix for KB948109 failed and messed the SQL services up. I rebooted and tried to reinstall it and the same thing happened, although this time simply restarting SQL worked to fix it.

I'm going to look into this a bit later and get it fixed on but wanted to throw this up on the blog. It also brought to light that I need to get a monitoring system put back on this server. I used Alert Site in the past and they were great and were reasonably priced, so I'll probably go with them again.

Anyway, cheers for now...

Tom Hundley
Elegant Software Solutions, LLC

Trackback Print

Location: Blogs

Tom Hundley

SQL Server

Tags:

1 comments so far...

Re: KB948109 Security Hotfix Fails

I figured out the fix to this. It was ridiculous. The problem I had with this was a permissions issue on %C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data%. It said my account didn't have access to the directory, but it clearly did. It turns out the files in the directory were not inheriting permissions from the parent, and I did not have access to one of the files... so I fixed that and was good to go.

It looks like a lot of people had this exact issue.

By tom on 8/17/2008 11:32 PM

Your name:
Title:
Comment:

Add Comment Cancel