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

Unable to uninstall SCCM and DB

After running into trouble on our 'crash and burn (test)' SCCM server I decided to select the 'perform site maintenance or reset site' option in SP2 with

'reapply default file & reg permissions on site server'

'modify sql server configuration' and (probably what screwed things up)

 'modify sms provider configuration'.

 This ran into errors so I thought I'd simply remove SCCM completely and reinstall it with a fresh db. However I get the message:

 'setup was unable to create collections(s). Verify that your account has create rights on the collection class. 0x80041013'

 Now I am in limbo and unable to remove this at all in order to reinstall a fresh copy. I am no longer able to connect to the site via the console because the site can no longer connect to the db (on a separate box) and I believe this is why I  get the message above (rather than a rights issue), though I could be wrong.

Can anyone give me any suggestions how to fix this? I just want to install a fresh copy. I have a feeling the uninstall issue as I mentioned, is something to do with the fact it is trying to reach the SCCM DB which I believe was probably broken with the 'modify SMS provider' checkbox....please help!!!
0
bondy666
Asked:
bondy666
  • 5
  • 4
1 Solution
 
merowingerCommented:
Can you configure the Collection Permissons via this script here?
http://pleasepressanykey.blogspot.com/2011/04/vbscript-set-permissons-on-configmgr.html
C;COLLECTION;N/A;mydomain\johnwayne;FULL
0
 
bondy666Author Commented:
Nice script, will look at that for the future but unfortuantely can't seem to connect to the db anymore follow my site repair!
0
 
merowingerCommented:
So you now want just to uninstall the whole SCCM Server incl. the database but it fails or?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
bondy666Author Commented:
Yes. In fact by trial and error and using a different version of the uninstall plus several reboots, I have managed to remove it. However my problem now is that when I run SCCM setup to reinstall, my only choice is to install a secondary site. Any ideas?
0
 
merowingerCommented:
Please check the Registry Key:
HKLM\SOFTWARE\Microsoft\SMS\Setup
and first try to change it to value 0x000000FF (255)
and if this does not work backup and remove it.
0
 
merowingerCommented:
Also have a look at the Logfile ConfigMgrSetup.log located in the root of C:\
0
 
merowingerCommented:
Also make you you have correct media and not an SCCM Upgrade Media. Test the start of the setup process on a "clean Server"
0
 
bondy666Author Commented:
Hi this looks like it may simply be to do with some incorrectly labelled 'media'...will get back to you shortly!
0
 
bondy666Author Commented:
Wrongly labelled media for second part of the problem.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

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