• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

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
0
gmollineau
Asked:
gmollineau
  • 2
  • 2
2 Solutions
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now