Hello, We had a situation where we had to completely rebuild our SCCM environment. We had an SCCM site server and a separate SQL server. We left the old SCCM site and database on those servers for reference. We created a new SCCM system with
a new Site Name, and installed it on a new server. The new SCCM database was installed on the same SQL server in the same instance as the old SCCM database. The old WSUS database was deleted and a new one was created with the new SCCM system
installation. I cannot find any documentation that states that this scenario is not supported in SCCM 2007. Once we enabled the Reporting Services Point role, we began to see major errors in the SMS_SITE_COMPONENT_MANAGEMENT - SMS Site Component Manager
detected that site system <SQLserver> is currently in use by SMS site <old system>. Is there any documentation stating that installing two or more SCCM 2007 systems on the same SQL instance is not supported?
I can't find the documentation on it, but logically it is not supported. However, since you indicate that you have shutdown the other environment, it really is simply that you didn't (or were unable to) completely deinstall the old environment.
So in WMI on the server which you want to hold the reporting services role, there are still remnants of the old site.
Your best bet might be to open a call with CSS, and have them talk you through removing the old site information referenced in WMI.
If that is unappealing for whatever reason...you can also just elect a different server somewhere to be your "classic" or ASP reporting point. Personally, just look into using SRS reporting services instead. SSRS reporting is the future, and
you'll want to know it for CM12 anyway.
Standardize. Simplify. Automate.
Marked as answer byYog LiThursday, February 14, 2013 7:21 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.