Search code examples
db2webspherewebsphere-portal

WebSphere Portal 8 Installation - Trial Installation

Trying to install IBM WebSphere Portal 8 Express Version from this link.

Once the installation starts, below error is captured in the Installation Manager logs.

 [exec] C:\Program Files (x86)\IBM\WebSphere\ConfigEngine>db2 -v "CREATE DB wpsdb USING CODESET UTF-8 TERRITORY US PAGESIZE 8192" 
 [exec] CREATE DB wpsdb USING CODESET UTF-8 TERRITORY US PAGESIZE 8192
 [exec] SQL1092N  "XXXXXXX" does not have the authority to perform the requested 
 [exec] command or operation.


 [exec] C:\Program Files (x86)\IBM\WebSphere\ConfigEngine>db2 -v "UPDATE DB CFG FOR wpsdb USING applheapsz 4096" 
 [exec] UPDATE DB CFG FOR wpsdb USING applheapsz 4096
 [exec] SQL1013N  The database alias name or database name "WPSDB" could not be found. 
 [exec] SQLSTATE=42705

Additional Details:

  • OS - Windows 10
  • User used - Is an admin, also added to the user groups DB2ADMNS and DB2USERS.

  • Purpose - Setup an existing project on Portal 8 and then upgrade to Portal 9.

    Any suggestion or link to download IBM WebSphere Portal Enable/Extend version will help.

Solution

  • The issue is that the Portal Installation has an integrated DB2 setup which tries to add users to Domain instead of the Local Machine. In order to fix this, create an user in the local system and add the user to these user groups - Administrator, DB2ADMNS and DB2USERS.

    Steps to add user:

    1. Type lusrmgr.msc from command prompt.
    2. Add User from "Local Users and Groups > Users" tab.
    3. Add User to Administrator, DB2ADMNS and DB2USERS groups from "Local Users and Groups > Groups" tab.

    Thanks @mao for the clue.