Retinaburn

HI All Looking for some advice here, we (the royal we) are trying to upgrade our SCCM 2012 R2 servers so they use SQL 2014 database instances. Annoyingly for me and some other members of my team our company policy denotes that all SQL Db's be managed solely by our DBA's. They tried to upgrade our SQL 2008 r2 db's to 2014, but no by doing an in place upgrade but by creating a new sql server instance on the same Windows server. So now we have a sql 2008 r2 instance and a 2014 instance running on the each of our sccm sql servers (this is with a CAS and 2 Primary Site Servers, each with a seperate server for the database, don't ask why i had nothing to do with the initila config and heirachy.) We are now seeing errors on the PSS DB's accessing the CAS DB relating to certificates. If the DBA's have setup the domain service accounts to run sql but have not imported the certificates to the accounts personal certificate store, would this cause this problem? Currently we have the 2 PSS server databses running both SQL instance, any idea what problems this could cause SCCM if any? I have no idea why they didn't do an in place upgrade but i am guessing the DBA's were worried it might cause problems! Any help or advice would be appreciated. regards Keith

Hi All I am a systems admin at my company and have been trying to understand our currenty SCCM 2012 set up. We currently have a CAS with 2 primary sites which support multiple domains. I have been told that the choice to go for a CAS was for policital reasons but these reasons do not really seem to make any sense to me. The 2 primary sites are for our comapny which is the service provider and then for the company that we support. Now if the company that we support chooses to go elsewhere and use a different provider can the primary site server which supports their domain be separated from the CAS heirarchy or would they need to start from scratch? To me it seems that it would be better (maybe more of a management headache for the administrators though) to go down the route of having just primary site servers for each separate company. Any advice would be appreciated.