You receive a “Cannot insert the default site control image to the database” error message when you try to perform a site reset in Systems Management Server 2003

When you try to perform a site reset in Microsoft Systems Management Server (SMS) 2003 after you reinstall or upgrade your Microsoft SQL Server installation, you receive the following error message:
Additionally, you cannot connect to the SMS site database by using the SMS Administrator Console.

Typically, this problem occurs when the xp_SMS_notification extended stored procedure is removed during the SQL Server installation process.

The xp_SMS_notification extended stored procedure is added when you install SMS 2003. If you reinstall SQL Server, the xp_SMS_notification extended stored procedure may be removed.

To resolve this problem, you must re-create the xp_SMS_notification extended stored procedure by using SQL Enterprise Manager. To do this, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In SQL Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand ServerName, expand Databases, and then click master.
3. In the right pane of SQL Enterprise Manager, right-click Extended Stored Procedure, and then click New Extended Stored Procedure.
4. In the Extended Stored Procedure Properties - ServerName dialog box, type xp_SMS_notification, and then click the ellipses (...) button next to Path.
   
   Important The Extended Stored Procedure name is case-sensitive and must be entered as xp_SMS_notification.
5. In the Locate Extended Stored Procedure .DLL dialog box, locate the \SMS\Bin\i386 folder, click smsxp.dll, and then click OK two times.

For additional information about the site reset function in SMS 2003, click the following article number to view the article in the Microsoft Knowledge Base: