[FAQ][SMS] "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 - Click HERE to access the article]






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 8:42 AM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS
Filed under: , , ,