EBIworld.com

Scenario:

After setting up EBI Data Source we encountered an error when attempting to retrieve database tables.

Issue:

iSeries user is not set-up to allow for SQL Server access.

 
PowerTech Network Security 
All Network Security Groups - Rejected Transactions                                    

Taken  Group           Name       Name         Date     Time   User       Job Number/User/Name       Transaction                 

------ --------------- ---------- ---------- -------- -------- ---------- --------------------------------------------------------

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 10:59:37 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:23 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:41 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa

Reject *NOGRP          *SQLSRV    EXECUTE    03/25/15 11:02:58 SHOPPE    885038/QUSER/QZDASOINIT     Server does not supply transa
     

EXTOL pop-up error message:

In EXTOL Business Integrator, a pop-up window is displayed indicate UNABLE TO LOCATE SCHEMA.

Resolution:

iSeries administrator must permit user to have *SQLSRV access, as such in example below.

	                                        Filter Rule Properties            

User        Server ID   Function    Authority   Aud  Msg  Cap  Switch Profile 
QSECOFR     *FTPSERVER  *ALL        *OS400       *    *    *   *NONE          
QSECOFR     *RMTSRV     *ALL        *OS400       *    *    *   *NONE          
QSECOFR     *SQLSRV     *ALL        *OS400       *    *    *   *NONE