We just recently deployed our hosted ArcGIS Portal pointed towards our LGIM SQL database as a managed database and I can't publish any solutions using the deployment tool. I see the following error message every time:
I just got off the phone with ESRI support and he said that the managed database for Portal can't be a SQL database, you have to be using the ArcGIS Data Store. He also said we can set one up but that it won't hook into SQL. Any changes made to the data in SQL after a solution has been deployed to the ArcGIS DS won't be reflected until you re-deploy the solution. He said that I can still use ArcMap to deploy the solutions manually but what am I supposed to do in the future? Aren't we supposed to be moving towards ArcGIS Pro? Our entire ESRI environment was just deployed using the SQL LGIM.
Is there anyone out there that is using ArcGIS Pro with SQL and is deploying solutions with the deployment tool?