Microsoft KB Archive/889433

= 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 =

Article ID: 889433

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
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:

Cannot insert the default site control image to the database.

Additionally, you cannot connect to the SMS site database by using the SMS Administrator Console.



CAUSE
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.



RESOLUTION
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  , 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 -   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.
 * 1) In the Locate Extended Stored Procedure .DLL dialog box, locate the \SMS\Bin\i386 folder, click smsxp.dll, and then click OK two times.



MORE INFORMATION
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:

828366 How to use the site reset functionality in Systems Management Server 2003

Additional query words: site reset SQL Server

Keywords: kbtshoot kbprb KB889433

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.