SAP HANA 2.0 Express Edition | URLs, Permissions and Configuration for the Web Dispatcher

[stefan_seemann]

SAP HANA comes with different tools that can be accessed via Browser. The URLs, of course, differ and also require certain permissions. In addition some minor configuration to the SAP HANA database needs to be done to make all tools fully available.

This is a list of all my blog-posts about those tools:

URLs, Permissions and Configuration for the Web Dispatcher

URLs, Permissions and Configuration for the HALM

URLs, Permissions and Configuration for the Web-based Development Workbench

URLs, Permissions and Configuration for the XS Classic Server

URLs, Permissions and Configuration for the HDBLCM

URLs, Permissions and Configuration for the SAP HANA Cockpit for Offline Administration

 

In this blog I explain how to access SAP HANA's Web Dispatcher. It exists only once in a SAP HANA Instance and is administrated via the System Database. More information can be found in the SAP HANA Admin Guide.

I am using SAP HANA 2.0 Express in a VM Ware Container.

How to download & install SAP HANA Express is explained in this Youtube-Video

I am using the Package “Server only virtual machine”.



To be able to administrate the Web Dispatcher of SAP HANA a small configuration change needs to be done. It is also explained in SAP Note 2107899 - HANA Web Dispatcher - Multi DB - Access to Administration UI is restricted to System DB us...

Required Configuration

Logon to the System Database in SAP HANA Studio and navigate to the Configuration Tab.



SID is SYS. Now, filter for string enable_admin_ui.



Change $(SAPSYSTEMNAME) to SYS. Save the parameter and restart the Service. I restart the database using "HDB stop" and "HDB start" as user hxeadm.

Required Authorizations

Grant role "sap.hana.xs.wdisp.admin::WebDispatcherAdmin" to provide Administrator rights.



Statements are:

-- Create Administrator for Webdispatcher
create user wdisp_admin password Abcd12345 NO FORCE_FIRST_PASSWORD_CHANGE;

-- Grant Admin Role
call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.hana.xs.wdisp.admin::WebDispatcherAdmin', 'WDISP_ADMIN');

URL

The URLs of Web Dispatcher are:

http://hxehost:8090/sap/hana/xs/wdisp/admin/

https://hxehost:4390/sap/hana/xs/wdisp/admin/

When you see this:

Go back to Required Configuration. This is due to a wrong configuration, not about missing privileges.

Instead you should see the following.





Login was successful.

That’s it, thank you very much, please like and subscribe Feel free to leave a comment..