SQL 2008 SP1 Install

Question

Post reply

SQL 2008 SP1 Install

DBAgal

Hall of Fame

Points: 3185
More actions
August 13, 2010 at 10:23 am

#226029

Hi all -
I'm pulling my hair out.
I'm trying to get SQL 2008 SP1 installed on a one-node Windows 2003 cluster (the cluster is also running SQL 2005).
Everytime I go to install SP1, I receive an error message about mpt_agent_core_cni.
"A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [MPT_AGENT_CORE_CNI]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed."
When I run the repair option (I probably have a corrupt something or other), I get an error message indicating that the C:\Windows\System32\perf-SQLAgent... file is being used by another process. What is this process in charge of?
I really don't want to do a reinstall. Any other suggestions?
Thanks in advance for your help!
PS: SQL 2008 Enterprise Edition
Windows Server 2003 x64 SP2

Viewing 11 posts - 1 through 10 (of 10 total)

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

crazy4sql SSCoach Points: 19590 More actions · Answer 1

it seems like there was some installation in past which required server reboot and was not done.

I think reboot will resolve this problem.

----------
Ashish

DBAgal Hall of Fame Points: 3185 More actions · Answer 2

Hmm...

I rebooted before I went to install SP1. I installed SP1 and it erred out at the end. Every since, I've tried to repair the instance (got perf-SQLAgent error mentioned above) and the shared features. Would a reboot really do anything? Maybe kill whatever process is connected to the per-SQLAgent, so I can repair the instance?

I just did another repair of the shared features - error code 0x84B20001.

Blah.

crazy4sql SSCoach Points: 19590 More actions · Answer 3

"you must resolve any issues with the previous operation that failed"

that is the only assumption I have from this error.

----------
Ashish

DBAgal Hall of Fame Points: 3185 More actions · Answer 4

Rebooting didn't fix either problem... =(

Any other suggestions?

Thanks!

crazy4sql SSCoach Points: 19590 More actions · Answer 5

Sorry to hear, just suggestion, can you try to run repair for sql server?

----------
Ashish

DBAgal Hall of Fame Points: 3185 More actions · Answer 6

I was finally able to figure this out without doing a re-install.

I have monitoring software on the server that I was installing the SQL 2008 instance on; a 2005 instance currently resides on the server/node already. The monitoring software service was using a shared file that SQL 2008 needed in order to be repaired. Once I was able to figure out the process that was being used by the monitoring software, I was able to kill it. I used the Process Explorer tool to figure it out. Once the process was killed, the Repair ran successfully. Once the Repair ran successfully, the Service Pack could be installed successfully.

Hope this solution helps someone out in the future.