JSQLConnect MS SQL Server Connection Issue.

Hi Masters ,

Please have a look on the following issue :

We have a MS - SQL Server 2005 Server which is accessed through
many client machines . We use JSQLConnect to communicate with
the server from client machine. Problem is when we enable SECURITY
on the server machine , the communication fails with the following
error :

Log:Cannot connect to database,
reason:com.jnetdirect.jsql.JSQLException:
Failed Logon:com.jnetdirect.jsql.JSQLException: DBComms.error reading
input. Context:Read packet header, Unexpected end of stream,
readBytes:-1, negative read result, PktNumber:0, ReadThisPacket:0,
PktDataSize:4096 url:jdbc:JSQLConnect://localhost/database=master/
user=sa/password=<Password>


Any Idea why it is failing ? Do I need to install a certificate on my
SQL Server , if
Yes KINDLY LET ME KNOW THE PROCEDURE. I tried installing certificate
Through MMC but an erro message appears saying “ No certification
authority found”
We don’t have a certification authority , so please let me know an
alternate solution for
This.

My Environment is as follows :

JDK 1.5
Platform : HP-UX & Windows 2000
JSQLConnect 5.5

Thanks to you all in advance , Any response is most welcome 

Thanks & Regards,

Sudhansu Tiwari

.

Relevant Pages

  • Re: Certificates with Makecert.exe
    ... Installing CA root cert on client machines, ... > Would there be any limitation to the ammount of users that> I could distribute this certificate to, and the ammount of> users that would be able to be verified against the private> certificate I create on the server? ... >>If you take care of the trusted root cert on client machine. ...
    (microsoft.public.inetserver.iis.security)
  • Re: SSL self-signed certificate
    ... On your client, open SQL Server Configuration Manager, right-click SQL ... What's your Trust Server Certificate setting? ...
    (microsoft.public.sqlserver.security)
  • SSLSecurity error - sql/certificate server on same machine - cannot connect to db server
    ... i have a windows2003 machine with sql server SP3. ... installed certificate services on the same machine, ... i searched the internet and found some articles like ...
    (microsoft.public.sqlserver.server)
  • SSLSecurity error - sql/certificate server on same machine - cannot connect to db server
    ... i have a windows2003 machine with sql server SP3. ... installed certificate services on the same machine, ... i searched the internet and found some articles like ...
    (microsoft.public.sqlserver.security)
  • Re: RRAS/NAT connected stations cant access websites
    ... Did you use the same model NIC on all the client machines? ... Download the Network Edition of MPS_Report tool from ... run it on the RRAS Server and client machine. ... |> the external DNS Server IP address provided by ISP to do the test. ...
    (microsoft.public.windows.server.networking)