Sunday, 18 July 2010

MS SQL Server Installation Problem

Days ago some of my clients reported an error when installing Microsoft SQL Server 2005. The error was:

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.

This error is mainly caused by having an incorrect date and time. To solve this issue, simply check your date and time setting and reconfigure it with correct values. That's all!