Hello Benjamin, Apologies for not replying to your response sooner. It's likely there is some failure in the sync process that causes the collaboration to share the item as a reference. In order to further constrain the point of failure we would need to review the collaboration sync status and portal logs. This would likely give us more information regarding which step of the sync process is failing. If you want to troubleshoot further and have access to the logs I would recommend creating a support case. I would also recommend the following workflow for items that revert to share as reference: Review the hosted feature layer settings. Ensure the feature layer remains sync enabled. Remove the hosted feature layer from the collaboration group in portal. Initialize a sync, this will remove the associated hosted feature layer in ArcGIS Online. Re-share the hosted feature layer to the portal collaboration group. Any follow up questions please let me know. Thanks, Thomas.
... View more
Hello all, I have Enterprise 10.6.1 running in Azure with a federated portal. We also have an Azure managed SQL instance that which is validated/registered as a data store in server manager. The issue is that the same database fails when I try to add it as a registered data store in ArcGIS Pro 2.4.1 (and 2.4). When I enter the instance and the username/password it populates the Database drop-down with the only database available but fails to connect (see error dialog below) when I click the create button in the Register Database dialog box. This dialog box below offers no information on the type of error. I can connect to this database using ArcMap 10.7.1 and using SSMS. Any help would be greatly appreciated and thanks in advance! -Ben
... View more