Re: How to get FreeTDS to work with Microsoft SQL 2000 with encryption from Linux...

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <1251560704.5638.5.camel@freddy>
Il giorno ven, 28/08/2009 alle 21.42 +0000, Reese, Donald (Don) ha
scritto:
> Greetings,
> 
>  
> 
> I am new to the list and simply have not been able to find an answer to
> this issue:
> 
>  
> 
> I need to connect from a CentOS box to a Microsoft SQL 2000 server using
> FreeTDS 0.82
> 
> I have tried the a DSN based connection so that I can enable the
> encryption feature, but still get the invalid login response.
> 
>  
> 
> The ini values that I am trying to use are:
> 
> tds version = 8.0
> 
> encryption = required
> 

Should work... have you tried without encryption parameter ??
Have you installed a certificate on the server ?? mssql 2005 install a
default certificate (self signed) while mssql 2000 require a manual
operation. Does ms odbc driver works with encryption forced on ?? If
reply is yes you should try a snapshot.

>  
> 
> I have tried looking for more information but this appears to be the way
> that the configuration should work.
> 
> I must be overlooking something.
> 
>  
> 
> Thanks,
> 
>  
> 
> Don
> 

Regards
  Frediano Ziglio
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.