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
gmollineauAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel WilsonCommented:
Are you sure you're providing the correct SQL Server name (with instance name if not a default instance), DB name, user name, and password?

I ask these questions b/c it looks like an error trying to get a connection -- if I'm reading that JDBC error stack correctly.

Also ... is your SQL server listening on TCP/IP?  Is it allowing remote connections?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gmollineauAuthor Commented:
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.  
0
Daniel WilsonCommented:
But after all that configuration, it still fails w/ the same message?

Name resolution can sometimes be a problem ... Can you ping the SQL Server by name from the 400 ?  (I can't tell you how to ping from a 400 ...)
0
gmollineauAuthor Commented:
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?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Operating Systems

From novice to tech pro — start learning today.