The Multifunctioning DBA

Aug 20 2011   10:00AM GMT

SQL Server SP install Fail Issue



Posted by: Colin Smith
Tags:
Errors
SQL Server

Last week I came across a SQL Server that was running 2005 SP2 and I thought “hmm I should upgrade this to SP4′” So I got a time to do it and I went along my merry way. Well I started the install and everything installed just fine except the database engine failed. The error in the log file said something about the path for Temp_MS_AgentSigningCertificate_database was not available. I thought this is strange since this is not a database on the server and I do not see it anywhere. I beat my head against the wall for a few minutes and then it came to me. AWW I bet that is something that the SP is putting on the Server for the install process. So I opened up SSMS and looked at my Default database location setting and found that someone had changed them to a disk that does not exist on the server. I changed that to a Valid path and re-ran the SP installer and what do you know… it all worked. So keep an eye out for that and I hope that you find this before you beat your head against a wall.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: