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


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. [17/10/2012 - The WMUG Link Below No Longer Works - Please click HERE to access the Article]

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

Published Wednesday, August 04, 2010 8:43 AM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS
Filed under: , , ,