When running Configuration Wizard, the 'websites' table is always updated, and this causes problems. We use internal domain certificates for our servers, and after we've bound the cert, we remove the other record from the websites table (the one with the server name). So we end up with only one entry in the websites table that reflects the dns name (cname actually), and that one entry is the 'Primary'. We also check the 'ReportJobs' table to make sure WebsiteID contains ONLY the entry we have in the websites table.
Once all this is set up, running Configuration Wizard (with Website option) updates the websites table again, and we have to clean it up again. "Skip website binding" does not help with this issue (whether checked or un-checked). Seems like "Skip website binding" should leave EVERYTHING along, including the websites table. Or with "Skip website binding" unchecked, which gives the ability to bind your cert, that should update the websites table specifically for the cert you choose to bind on this screen.
This issue is a pain in the butt, and we have to plan for this extra step of cleanup whenever we run Config Wizard with the Website option. Can we please make this work better?
We opened a support case (1232467) and a feature request was submitted to the SolarWinds dev team upon closing the support case.
