• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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