cannot get DBI:ODBC connection to mssql instance that requires ssl

I am trying to connect to a MsSQL server instance that requires ssl (it
has the 'force protocol encryption' check-box checked), but have not
been able to.

The sofware involved is:
- the server is mssql server 2000
- the code to connect is running on a linux box with:
perl v5.8.8
DBI v1.51
DBD::ODBC v1.13
freetds v0.64 odbc driver (and freetds was compiled with ssl support
enabled)

There are 2 instances of the MsSQL server, one listening on port 1433,
and not requiring ssl, and one listening on port 2943, requiring ssl.
I can connect to the former, but not the latter.

My /etc/odbc.ini looks like:
[ODBC Data Sources]
JBAR = Mssql Jenzabar Server

[JBAR]
Driver = /usr/local/lib/libtdsodbc.so
Description = Mssql Jenzabar Server
Trace = No
Server = bla.msoe.edu
Port = 1433
Database = TMSEPRD
TDS_Version = 7.0

[JBARS8]
Driver = /usr/local/lib/libtdsodbc.so
Description = Mssql Jenzabar Server
Trace = No
Server = bla.msoe.edu
Port = 2943
Database = TMSEPRD
TDS_Version = 8.0

The error message I get when trying to connect to jbars8 is:
DBI connect('jbars8','loginman',...) failed: [unixODBC][FreeTDS][SQL
Server]Login failed for user 'loginman'. (SQL-42000)
[unixODBC][FreeTDS][SQL Server]Login incorrect. (SQL-28000)
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
(SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./dbdodbcTest line 6
Failed to connect to db dsn=jbars8 : [unixODBC][FreeTDS][SQL
Server]Login failed for user 'loginman'. (SQL-42000)
[unixODBC][FreeTDS][SQL Server]Login incorrect. (SQL-28000)
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
(SQL-08001)(DBD: db_login/SQLConnect err=-1)

By packet sniffing, I can see that packets are going to the server on
the desired port, and coming back from the server, so I know that the
code is finding the correct db instance. Also, the tsql binary, that
comes with freetds, is able to connect to the jbars8 instance, so i
know that the db instance is working properly.

Thanks for any help you lend

.

Relevant Pages

  • RE: pen-test on a windows 2003 server box whit MS-SQL and Terminal Services
    ... Depending on the setup of the MSSQL server, try the DYNSA account ... pen-test on a windows 2003 server box whit MS-SQL and Terminal Services ... i tried a dictionari atack on mssql server whit the "sa" account and others user names i collected. ...
    (Pen-Test)
  • Floodingschutz beim MSSQL Server mit PHP?
    ... ich greife mit PHP auf einen MSSQL Server zu. ... Ich habe mehere PHP Skripte, ... Kombination mit gewissen Links auf meiner Seite klicke so kann es dazu ... Es sieht also so aus als ob der MSSQL Server es irgendwie ...
    (microsoft.public.de.sqlserver)
  • JDBC to Microsoft SQL
    ... While I can execute sub-select statement directly on a MSSQL server, ... I am connecting to database server without any settings, just IP, ... Is there any setting I can specify which can help me? ...
    (comp.lang.java.programmer)
  • Java and Microsoft SQL
    ... While I can execute sub-select statement directly on a MSSQL server, ... I am connecting to database server without any settings, just IP, ... Is there any setting I can specify which can help me? ...
    (comp.lang.java.databases)
  • Most users cant connect to our SSL-- help!
    ... I've included all relevant SSL settings from our ... Subject: Large percentage of customers cannot connect to https: ... server, which then grinds indefinitely. ... "2) Your secure order form is not working. ...
    (comp.security.misc)