I'm trying in 5.3.3 passing id/password from MVS/SCCTL IWAY Hubserver thru a Windows IWAY subserver for validation on an individual user id basis against MSSQL database tables. What are the settings for the Node Connection on MVS to the MS/IWAY box and then the connection attribute to the MSSQL server for passthru(if that what I should be doing) or if it should be a "trusted" connection then what or Security ON? I can't makes heads or tails out of the document for this case where the MS/IWAY server is not the hub but rather a sub.

Hi mchuss
Lets first start with the NT server. Start it with security off and then start the web console (WC). In WC navigate to Data Adapters>add>ms sql server. Input connection name, server and select password passthru (enter default database is optional) select configure.
Now navigate to home page of WC and select workspace>configure>access control. The security_dbms and security_connection dropdown boxes should now show the ms sql connection previously configured, select it in both boxes. While you are on this panel, select server_admin_id dropdown box and select new Id. Provide the userid (password not required) of a userid in MS SQL Server that you want to use as an admin userid on the WC. Click ADD button and then click save button, now stop the server by workspace>stop. Now from the start menu of windows start the 5.3.3 server in DBMS mode (iway software>iway 533 ...>start with alternative security modes>dbms. The NT server is now running with DBMS security and you must now use a valid userid/password from with in MS SQL Server to access the webconsole and/or connect to the server from your appliaction (or SSCTL server). Don't forget that the userid you use to access the Web Console should be the one you added in the workspace>configure>access control panel earlier on. If you use any other userid you will not get administration rights within the WC.
Now to the SSCTL server. I will assume that you installed a WebFOCUS reporting server using userid "mchuss". In your INSTALL.DATA file edit member FFSCSG and add a block that points to your NT server
NODE = ARHNT
BEGIN
PROTOCOL = TCP
CLASS = CLIENT
HOST = EDAARHXP
SERVICE = 8100
END
Now add an entry to your FMCHUSS member in EDAPROF.DATA
SQL EDA SET CONNECTION_ATTRIBUTES ARHNT/uid,pwd
where uid,pwd is a valid userid/password in MS SQL Server
I hope this helps