gmollineau
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
ASKER
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.