Good afternoon.
Our organisation runs Enterprise 11.3. Our data is held in an Enterprise Geodatabase hosted in an Azure SQL Logical Server.
For many years we have accessed the data in the SQL database using SDE connections in ArcGIS Pro from various Azure VDIs without any significant issues. We are now looking to enable access to the same database from local workstations using the same SDE connections but are having mixed results.
More often than not when attempting to connect to the database we receive a somewhat generic error message: "Failure to access the DBMS server []". While at other times we are able to connect using the same connection file without any issues - we can see and load the data. There's no apparent rhyme or reason as to when it will or won't connect. In come cases, it's a matter or waiting for a period of time and it will connect.
We have tried connecting from various workstations, all with the same mixed results. We are able to ping the SQL server instance, which is always successful with virtually no delays.
Just wondering if anyone has had this experience and can suggest any solutions.
Thank you
Peter
