Support Tip: ConfigMgr 2012 Setup fails at Prerequisites Check with error “Failed to connect to registry on machine SQL (FQDN)”

Consider the following scenario: When running setup for System Center 2012 Configuration Manager (ConfigMgr 2012), in the Setup window you receive the following warnings: <A communication error has been detected between the specified site system and the site database computer. This error can occur when the site database server is offline or if a valid… Read more

KB: After moving the System Center 2012 Configuration Manager SQL Site Database to another drive, creating a new Software Update package or a new application fails

Here’s a new Knowledge Base article we published today. This one discusses an issue where after moving the System Center 2012 Configuration Manager SQL Site Database to another drive, creating a new Software Update group, Software Update package, or creating a new application fails. ===== Symptoms After moving the System Center 2012 Configuration Manager SQL… Read more

Fix: Unable to connect CAS or Primary to the SQL database during the System Center 2012 Configuration Manager setup

Hi everyone, Dennis Donahoe here with a couple tips on how to fix an issue you may see setting up a new install of Configuration Manager. In a new installation of System Center 2012 Configuration Manager (ConfigMgr), you may find that you cannot connect to SQL when installing with a remote SQL 2008 R2 SP1… Read more

How to configure ASP.NET with ConfigMgr 2007 and SSRS on the same computer

On 64-bit operating systems, some IIS-based Configuration Manager 2007 roles (Management Point, etc.) require 64-bit ASP.NET components to be registered.  If we register 32 bit components instead of 64 bit (only one can be registered at the same time), these Configuration Manager roles may stop working. Note: You can register these components based on this… Read more

How to easily test your remote SQL connectivity

Microsoft’s own Steve Rachui explains how to quickly and easily test remote SQL connectivity using any account you like.  This is a neat trick that will surely prove useful when working with a wide variety of products. J.C. Hornbeck | System Center Knowledge Engineer The App-V Team blog: http://blogs.technet.com/appv/ The WSUS Support Team blog: http://blogs.technet.com/sus/… Read more

Troubleshooting Duplicate or Missing SPNs for a ConfigMgr 2007 SQL Database

This blog post addresses a common problem customers face during the installation of System Center Configuration Manager 2007 in which the following error appears: “Setup failed to install SMS Provider.” When this error occurs, there are several possible causes, but the first thing I check is Service Principal Names or SPNs. Background When setting up… Read more

New KB: Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services

Symptoms Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services. Problem 1: Trying to access http://<SQLServerName>/reports returns blank window.  Problem 2: When trying to execute one of the reports you get the following error:  An error has occurred during report processing. (rsProcessingAborted) Cannot create… Read more

Overview of Opalis Integration Server connectivity requirements

This article outlines the connectivity requirements for the various Opalis Integration Server components to interact with each other.  If firewalls exist between the various components, rules may need to be introduced in your environment in order to allow the components to communicate. The core components of an Opalis Integration Server implementation are: Microsoft SQL Server… Read more

Create a Robust, Integrated Reporting Solution with SQL Server Reporting Services and System Center Configuration Manager

With the R2 release of System Center Configuration Manager 2007, the product now supports the use of SQL Reporting Services as a reporting solution.  This is the direction for reporting going forward and it offers a good number of exciting possibilities for building great custom reports.  In the January edition of TechNet magazine, our very… Read more

ConfigMgr 2007: How to move the Site Database

I was having trouble finding this post on the old SMSandMOM blog without a direct link, and saw this question asked on an alias so I thought it would be worth posting again on the new blog site for ConfigMgr 2007. This post describes how to move the Site Database for Configuration Manager 2007 to… Read more