title: SAP HANA configure XS Server for multitenant DB (via webdispatcher.ini and xsengine.ini)
body: <p>How can I configure the XS server in SAP HANA SPS 09?</p>
  
  <p>So far I figured out</p>
  
  <ul>
  <li>"System Database" is the main database and central configuration.</li>
  <li>"System Database" is connected using the tenant name "SYSTEMDB"</li>
  <li>"System Database" contains webdispatcher.ini, deamon.ini, etc. within "Hana Studio" -> "Administration -> "Configuration"<br>(the tenant databases do not contiain those configuration files)</li>
  <li>Reading the tutorial <a href="http://scn.sap.com/community/developer-center/hana/blog/2014/12/09/hide-and-seek-in-xsengine--expose-http-access-to-multitenant-database-containers-in-sap-hana-sps09" rel="nofollow">Exposing HTTP access to multitenant database containers in SAP HANA SPS09</a> helped me to configure XS for the main database.</li>
  </ul>
  
  <p>Unfortunately the configuration Steps in the HANA Administration Guide - Chapter 3.2.1.8 "Configure HTTP Access to Multitenant Database
  Containers" do not succeed. Neither the SQL Statements nor the configuration via GUI seem to have any impact.</p>
  
  <p>Configuration commands:</p>
  
  <pre><code>ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', ' &lt;tenant_DB_name&gt; ') SET ('public_urls', 'http_url') = 'http:// &lt;virtual_hostname&gt; :80 &lt;instance&gt; ' WITH RECONFIGURE;
  ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', ' &lt;tenant_DB_name&gt; ') SET ('public_urls', 'https_url') = 'https:// &lt;virtual_hostname&gt; :80 &lt;instance&gt; ' WITH RECONFIGURE;
  </code></pre>
  
  <p>Result command leads to the same results as before:</p>
  
  <pre><code>SELECT KEY, VALUE, LAYER_NAME FROM SYS.M_INIFILE_CONTENTS WHERE FILE_NAME = 'webdispatcher.ini' AND SECTION = 'profile' AND KEY LIKE 'wdisp/system%'
  </code></pre>
  
  <p>Also according to <a href="http://scn.sap.com/community/developer-center/hana/blog/2014/12/09/hide-and-seek-in-xsengine--expose-http-access-to-multitenant-database-containers-in-sap-hana-sps09" rel="nofollow">Exposing HTTP access to multitenant database containers in SAP HANA SPS09</a> you should make a new entry within webdispatcher.ini -> profile<br>
  I am able to edit the existing wdisp/system_0 (which was required to get XS working for the system DB<br>
  Unfortunately I am not able the add wdisp/system_1 parameter since "Add Parameter..." Context menu is missing for the webdispatcher.ini</p>