locked
ADFS 2.0 move configuration database from one SQL to another SQL server RRS feed

All replies

  • move the adfs dbs, then retarget the connection string for the config db on an adfs sts server (step 5), then retarget the artifact db (step 7) and on all other adfs sts servers if any only retarget the config db only (step 5)

    Basically similar procedure


    Jorge de Almeida Pinto [MVP-DS] | Principal Consultant | BLOG: http://jorgequestforknowledge.wordpress.com/

    Monday, May 13, 2013 6:57 PM
  • Hi Jorge,

    Why skip step 7(retarget artifact db) for the other "secondary"(since every ADFS is master in a SQL setup) ADFS servers? Or is this artifact db connection string somehow retrieved from the SQL db?


    Find me on linkedin: http://nl.linkedin.com/in/tranet

    Wednesday, May 15, 2013 1:13 PM
  • the config DB connection string is set on a PER SERVER basis, therefore you must adjust it on ALL ADFS STS servers. The artifact DB connection is an ADFS property stored in the config DB, therefore changing it once on one ADFS STS server is enough

    Jorge de Almeida Pinto [MVP-DS] | Principal Consultant | BLOG: http://jorgequestforknowledge.wordpress.com/

    Wednesday, May 15, 2013 1:20 PM
  • I just adjusted the article as it also applies to the migration from WID to SQL

    Jorge de Almeida Pinto [MVP-DS] | Principal Consultant | BLOG: http://jorgequestforknowledge.wordpress.com/

    Wednesday, May 15, 2013 1:28 PM
  • The artifact DB connection is an ADFS property stored in the config DB, therefore changing it once on one ADFS STS server is enough

    Tx!

    Find me on linkedin: http://nl.linkedin.com/in/tranet

    Thursday, May 16, 2013 7:06 AM