So we're trying to attempt to downgrade our SQL license from SQL Enterprise to SQL Standard.
I had previously asked on what changes, if any, had to be made to the ADFS side of things. We had issues backing up the previous DB and restoring it however.
So our DBA suggested to set up both SQL Enterprise and Standard on the DB server and cutting over ADFS to point to the new DB instance (under SQL Standard). But I'm not entirely sure of the properly protocol for getting this done.
I found the following guide:
https://social.technet.microsoft.com/wiki/contents/articles/948.ad-fs-2-0-migrate-your-ad-fs-configuration-database-to-sql-server.aspx
I'm looking at Step 3, part #7:
Add-pssnapin microsoft.adfs.powershell
Set-adfsproperties –artifactdbconnection “data source=<SQLServer\SQLInstance>; initial catalog=adfsartifactstore;integrated
security=true”
I'm assuming that since we have both SQL Enterprise and SQL Standard running on the same server, and that the "new" SQL Standard install has it's own new instance, that I would just need to follow the two commands in part #7 and be OK.
Seems like it should be more complex than that however. Again, still pretty new at this and want to make sure that this makes sense.
Thanks for any type of insight on this subject. I know it's kind of an odd approach.
