Symptoms
When a customer clicks the button Allow external access for a database in CCP, an error message appears:
Operation cannot be performed Database service <SERVICE_ID> has no external access.
Cause
Database server that hosts this database has only one IP which is internal. When one clicks Allow external access, the following select is performed:
SELECT 1 FROM dbm_services WHERE service_ip != comm_ip AND service_id = <SERVICE_ID>
If there is no external IP address, the query returns nothing.
Resolution
The database server should be re-added to POA with an external IP address.