• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Configuration Manager Reinstall

I need to reinstall SCCM 2007. We had a vendor do the original install and the server that held the Configuration Manager software died and is not recoverable (long story). The database was installed on another server and is intact.

It was a mixed mode install and I know the Site Code, Database name etc...We have 1800 clients in place but no site server. I've rebuilt the server and installed all the pre-requirements but when I run the install, it looks like it wants to re-create the database. Is it possible to just attach to the existing DB and reset the site or am I better off installing with a new site and DB and repointing the clients(if possible) Thanks.
2 Solutions
Do you have a backup from SCCM (i.e. from the Site Maintenance Tasks)?  If you do you can use the ConfigMgr Site Repair Wizard to restore the site (because it's not just the database, but also registry keys and files like the Site Control file that you need to restore).

If you don't have the backup, you are probably better off creating a new site and DB.  There are two approachs to this,

(1) if you use the same servername and sitecode, then all you need to do is to reset the trusted root key on the clients.

(2) If you use a different servername and sitecode, then you need to reassign the client to the new site.  You can do this via group policy using the ConfigMgr2007Assignment.adm template or via running a script on the client.  

If you decide to run a script on each client, I find the best way is to use a GPO Computer Startup Script

You can assign a client to a site using vbscript using these two lines
  Set oSMSClient = CreateObject ("Microsoft.SMS.Client")
  oSmsClient.SetAssignedSite 'C00',0

You can delete an existing trusted root key using WMI (but you should only run it once per client)

Set objWMIService = GetObject("winmgmts: {impersonationLevel=impersonate}
Set TrustedRootKeys = objWMIService.ExecQuery ("Select * from TrustedRootKey")
For Each RootKey in TrustedRootKeys
tofarrellAuthor Commented:
Thanks. Since I don't have a backup I've decided to install SCCM on a Windows 2008 box instead of rebuilding on Windows 2003.

I'm going to go with option 2. I've got the server built and the prereqs installed so far.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now