- ‘Could not find stored procedure ‘master..xp_SMS_notification’. : SMSDBMON_SiteControl_ins’
- ‘Setup has detected an existing installation of the administrator console…’
- ‘Status of Targeted Resources’ shows as ‘Program failed (unexpected restart)’
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.
Close
Problem:
I’m trying to upgrade a SMS 2003 Secondary Site to ConfigMgr 2007 but the option to upgrade the Site is greyed out. I’m seeing this in the ConfigMgrSetup.log:
Setup has detected an existing installation of the administrator console. This server seems to be a site server for a secondary site. Because the current installation is a different version, you do not have the option of modifying the installation.
Close
Problem:
I’ve sent a Package to upgrade my SMS 2003 Clients to ConfigMgr 2007 but when I run the “Status of an advanced client distribution report” I’m seeing some machines reporting as “Failed” under the “Status of Targeted Resources“.
Drilling down I see a large number of machines reporting “Program failed (unexpected restart)“. How do I resolve this? [More...]
Close