Agreed!  One of their DBA's that was on the call sort of piped up and defended me ... he didn't say anything about my proposed design but he did say...

Sorry, the argument isn't over storing it as XML ... which was perhaps an explanation error on my part.  The argument is just over a single table with a blob...

So, thank you everyone for all the insightful help. I am appalled that I was overruled. My contract just got switched and after 20 years we are a...

Thank you Sue!  That is super helpful!

Haha yes, totally understood which is why I didn't post any scripts or anything.  Just looking for a high level functional type of approach.  I am the sole voice of...

Yes, but that didn’t work for me with the errors I was first getting when you said that. I just goofed and forgot to do that at the end...

Ok, I figured that out too... just had to run IE as administrator... 

Well, I solved my own thread today... guess I'm smarter than I think I am. 🙂 ...

Ok, so I fixed the errors... it had to do with FIPS encryption and I was able to update the web.config file to resolve that.  So, yay, the URL at...

Ok that didn't solve it... I was able to create an SSL URL with the server certificate we already have on the server.  I don't have IIS installed on the...

Ok I think I figured it out... I think it is restricting the site cause its not HTTPS .... how do I make the report server HTTPS? 🙁

Already running as admin and nothing was in the error logs... 🙁

.

Yea the logs for the security patch in the summary and detail just say everything was successful woo hoo.

But I guess the patch just didn’t get a chance to clean...