I think we need some more detail.
Do you have TCPIP set up on the AS/400?
Can you ping the IP Address of the AS/400 from another server or PC?
From which box are you getting the error message?
When you go into the TCP/IP Settings do you see that IP you have configured as Listening or Enable or off?
You need to make sure you have TCPIP Started on the AS/400. STRTCP command will fire it up.
Also what version of OS/400 are you running?
<i>Accessing MS SQL Server database from the iSeries</i>
Once you get the TCP/IP configuration correct, the next thing you’ll need is a driver from Microsoft to actually access the MS SQL Server database. Good luck getting Microsoft to give you one.
You might have success with Java and a JDBC driver (from Microsoft). The database vendor is responsible for making drivers available. They know the necessary protocols.