AX / Dynamics 365 For Finance and Operations blog

Sometimes you might want to remove the BYOD (Bring Your Own Database) connection strings from a Dynamics 365 for Finance and Operations database. This could be, for example, when you’ve copied a database between two environments, as the connection string can’t be decrypted on a different database server and might not be valid for the new environment.

Normally you would delete the settings from the Configure entity export to database within D365FO (Data management > Configure entity export to database). However, the connection string might be difficult to remove due to it having been encrypted on a different database server. It might also be that you want to delete the configuration strings before starting the D365FO services. You can quickly delete the configuration strings using the SQL statements below. Note that the actual update statement is commented out in the code below, in order to minimize the risk of inadvertently deleting the connection strings.

SELECT * FROM DMFDATASOURCE;

--UPDATE DMFDATASOURCE
--SET ENTITYSTORECONNECTIONSTRING = NULL
--WHERE ENTITYSTORECONNECTIONSTRING IS NOT NULL;