[FAQ][SMS] "Could not find stored procedure ‘master..xp_SMS_notification’. : SMSDBMON_SiteControl_ins"

Problem:


I’ve tried doing an In-Place upgrade of SMS 2003 to ConfigMgr but it gets part way through the process then displays a “Fatal Error” dialog box stating “Configuration Manager Setup cannot continue because of the following error: Setup cannot upgrade the ConfigMgr database. Contact your SQL administrator.”

If I look in the “ConfigMgrSetup.log” it states:

***SqlError: [42000][2812][Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure ‘master..xp_SMS_notification’. : SMSDBMON_SiteControl_ins

Cannot insert the default site control image to the database.

***SqlError: [42000][2812][Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure ‘master..xp_SMS_notification’. : SMSDBMON_Sites_ins

Cannot initialize the sites table in the database.

Setup has encountered fatal errors while installing SMS services.

 

 

Resolution:


This is a known issue as detailed in Microsoft Knowledge Base Article 556084 “xp_SMS_notification not found when Upgrade from SMS 2003 to SCCM 2007”

http://support.microsoft.com/kb/556084/en-us

 

 


 

Read the complete post at http://wmug.co.uk/blogs/cliffs_blog/archive/2010/08/03/faq-sms-quot-could-not-find-stored-procedure-master-xp-sms-notification-smsdbmon-sitecontrol-ins-quot.aspx

Published Tuesday, August 03, 2010 3:42 AM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS
Filed under: , , ,