Problems installing updates to SQL2012 Enterprise Edition

Question

Problems installing updates to SQL2012 Enterprise Edition

John_Hill

Ten Centuries

Points: 1173
More actions
July 12, 2014 at 11:17 pm

#293283

I'm getting an error when I install the update. I've tried installing SP2, and it updated the components, but not the database engine. I get the following error. I also get this same error installing the online-build-index hot fix.
It updated everything except the Database Engine.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

MikaS Ten Centuries Points: 1210 More actions · Answer 1

Hello,

Have you looked at Summary.txt and Details.txt files? These should be in the timestamp folders under \Setup Bootstrap\Log folder and have more details about any errors occurring during the update.

Mika Sutinen, Senior DBA
@SQLFinn on Twitter
Blogging at SQLStarters[/url]

John_Hill Ten Centuries Points: 1173 More actions · Answer 2

Ah, thanks. It appears this is an issue of .Net. It was installed, but the drive no longer exits. I'll try reinstalling the .Net libraries, and try it again.

John_Hill Ten Centuries Points: 1173 More actions · Answer 3

Ok, finally got a resolution on this. We actually had to call Microsoft. In my 18 years in IT, this is the first time I've ever had to do that.

Turns out it was not a .Net problem, but what led me to believe it was a .Net problem ended up being the problem.

When we first set up this server, we had the server team assign drive letters however they saw fit. I installed SQL Server like any good DBA would. I had decided that this server needed to match our other server as far as drive letters go, and I needed to do a re-install in order to change the collation to match the other servers. So, I changed the drive letter then reinstalled. Everything worked great, and we promoted the server to a production status. Any Community Update packages that we applied worked fat, dumb, and happy. We never had an issue with installing any updates until SP2.

Well, come to find out, SP2 was looking for install packages on the drive letter that no longer existed. I thought that was a bit odd. I would have assumed that the installer would either ask for the location path (like in the good old days) or the needed files would be included in the SP2 download, considering how big the SP2 file was. But, nope, it did not.

I wasn't the only one involved from our company working on this. What they told me was that the Microsoft person ran some program that gave a list of the "missing" packages and the location. I believe they changed the paths in the registry and then we were able to install the service pack.

Crazy and silly, but the SP2 installed just fine after that. I just hope we don't have any issues with the next update on it that we need to install.