LLI Wiki — My Digital Knowledge Base

SAP HANA: find SQL port numbers with M_SERVICES

Query SYS.M_SERVICES to list the SQL ports of a SAP HANA instance.

To find the SQL ports of a SAP HANA instance, query the SYS.M_SERVICES system view from any SQL client (hdbsql, SAP HANA Studio, etc.).

SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0

Explanation

Mastodon LLIMastodon SocialFosstodon