Provisioning new PWA site with new DBs with SQL TDE Encryption in PS2010 RRS feed

  • Question

  • Hello,

    Just a simple question.  I have a SQL 2012 server where I have implimented TDE encryption.  I noticed everytime I create a new PWA Site in PS2010 with new databases (Puiblised, Draft, Archive, and Reporting) the databases are created in SQL but are automatically encrypted with the TDE Master Key.  Normally only the master database should hold the TDE Master key no other "user dbs" should.  Does Project Server do this by design, and would it be safe to drop this Master Key from these databases?



    v/r JShidell

    Thursday, March 23, 2017 2:04 PM