How do I Remove SQL Provider that was previously installed on a remote SQL server
I’ve installed a SQL provider on a remote SQL box. Now I want to remove that SQL provider and then move my ConfigMgr SQL DB to that server.
The reason I want to remove the SQL provider is when I try to move the DB following this article
http://technet.microsoft.com/en-us/library/bb680707.aspx
I get this error:
Setup has detected that a SMS Provider is installed on the specified server. Please specify different server
My Goal is to move my site database to a SQL box that already has a SMS Provider installed. I want to remove that SMS provider and start over.
TIA!
Answers
1. The registry key is blocking the install of the new remote provider, so remove the HKLM\SOFTWARE\Microsoft\SMS\Providers key.
2. For the WMI hack, connect to root\sms with WBEMTEST and press the 'Enum Classes button'. No input is necessary, just press 'OK' to do an 'Immediate only' search. In the Query Results dialog window, click on the 'SMS_ProviderLocation' and press the 'Delete' key. Close out of all of these dialogs.
3. Delete the SMSPROV folder on the root.
4. Add the new site server machine as a local administrator and remove the old site server (if applicable).
All Replies
One would think that it ouwld be similar to the steps outlined here:
http://technet.microsoft.com/en-us/library/bb693923.aspx
Actually, I don't believe it does cover the uninstall process.
I thought Jeff had covered it in another thread, maybe in the General forum. I don't recall how, I thought it was a WMI deletion - root\sms\site_mcm (where mcm is the site code). There may have been more as well.
I'll take a look in the general forum...but if anyone (Jeff/Wally) finds out how...could you please post this process on how to uninstall the SQL provider.
Thanks!
1. The registry key is blocking the install of the new remote provider, so remove the HKLM\SOFTWARE\Microsoft\SMS\Providers key.
2. For the WMI hack, connect to root\sms with WBEMTEST and press the 'Enum Classes button'. No input is necessary, just press 'OK' to do an 'Immediate only' search. In the Query Results dialog window, click on the 'SMS_ProviderLocation' and press the 'Delete' key. Close out of all of these dialogs.
3. Delete the SMSPROV folder on the root.
4. Add the new site server machine as a local administrator and remove the old site server (if applicable).
