Link to home
Start Free TrialLog in
Avatar of gmollineau
gmollineauFlag for Trinidad and Tobago

asked on

How do I connect to mssql 2005 from and AS400

Hi,

I am trying to connect from an AS400 running v5r2 to a MS SQL 2005 database that is on a server with Windows 2000 Server service pack 4 as the OS. I have posted the question for  the AS 400 experts and it seems that everything is fine on the AS400 side. But I am getting the attached error when I try to run the program JDBCSQLTCL (this calls SQLSERVER program). I have tried the MS SQL JDBC driver version 1.0 and 1.1 and both give an unrecoverable error. When I use the 1.2 version I get a SSL error. Does anyone have any ideas?
error-message.txt
JDBCSQLT.txt
SQLSERVER.txt
ASKER CERTIFIED SOLUTION
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gmollineau

ASKER

Hi,
Yes the SQL Server name, DB Name user and password are correct. I went into the SQL Server Configuration Manager and configured TCP/IP. I went on the web and found a few sites that went through and configured the SQL for remote connection and followed all there instructions. But this is a new area for me as I am not that familiar with SQL configuration.  
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

Yes, I can ping the SQL server from the AS400. I tried using both SQL administrator and Windows administrator credentials with the same result. From the AS400 it seems that logon message is being sent but the server is not responding to the request. Is there a log on the SQL server side that I can check to see if there may be a problem there when the logon requests is sent?