SQL Failure Occurs During the Installation of HPC Pack 2008

Article ID: 2004738 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When trying to install the HPC 2008 Pack, you may get a failure during the SQL installation of the HPC Pack setup with the following error message:

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component. Refer to the server error logs and Setup logs for detailed error information.

If you look in the Application Event Log, you would find the event:

Source:           <MSSQL_instancename>
Event ID:          17063
Description:
Error: 50000 Severity: 20 State: 127 Cannot add stored procedure to component.
SYSDBUPG.SQL terminating.

Cause

This issue can occur when the date/time have been set incorrectly.  The incorrect date/time could potentially be caused by a weak battery on the motherboard that holds the CMOS/BIOS settings and causes it to lose the date/time.

Resolution

Confirm the date/time and time zone are set correctly.

More Information

The troubleshooting steps taken to confirm this issue, was to modify the SYSDBUPG.SQL file to print out more information. In the previous situation, the server had the year set for 2002. So the stored procedure will get "set bNewProc = 1".  As a result the SQL setup installation believes it is a new stored procedure, then makes a call to Exec sp_AddFunctionalUnitToComponent which is when the failure occurs with the error message.

Once the date/time were corrected to the current year on the server that SQL was installed on, the HPC 2008 Pack installation would install the appropriate SQL version successfully

Sample script used:

SELECT start = getdate() INTO #sysdbupg
go
.......
declare @start datetime
,@name sysname
select @start = start from #sysdbupg
declare newsysobjs cursor for select name from sys.objects where schema_id = 1 and
create_date >= @start
open newsysobjs
fetch next from newsysobjs into @name
while @@fetch_status = 0
begin
Exec sp_MS_marksystemobject @name
update #sp_table set bNewProc = 1 where name = @name
fetch next from newsysobjs into @name
end
deallocate newsysobjs
drop table #sysdbupg
go

.

Additional information:  Windows HPC Community Forums

http://social.microsoft.com/Forums/en-US/windowshpcitpros/thread/7b7fc1ca-c744-4696-9bab-fd3230f39455

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2004738 - Last Review: May 2, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft HPC Pack 2008
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2008 Enterprise Evaluation
Keywords: 
KB2004738

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com