Database connection lost after editing screen

I have added a database connection in Advanced Customisation / Tables and Databases.  I'm able to retrieve data successfully using the usual CRM objects.  However, if I edit a CRM screen layout and save it, the database connection disappears until I run a metadata refresh for Tables and Columns.  The self service database also disappears and reappears after the metadata refresh.  This is on CRM 2021 R1.

Is this a known issue?

Parents
  • 0

    It may be a known issue, but a long time a go I had an issue with a database connection disappearing and being a problem and it was because the database was on a SQL Express instance. By default databases on SQL Express are (or were) set up by default to auto close. Change this in the database properties so that it doesn't auto close. It may resolve the issue. I also had an issue once where the original database was a SQL Express instance and was upgraded over time to full SQL but this property stayed as the default for SQL Express.

  • 0 in reply to Vega

    I think that issue of the database closing is likely to be where you would get the "You may need to recreate views" type message - the closing of the database would be more severe that the invisibility of the metadata.

Reply Children
No Data