Skip to Content.
Sympa Menu

freetds - Re: [freetds] Need your help.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Paul Thurston" <pthurston AT netegrate.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>, <sandeep.poojary AT wipro.com>
  • Subject: Re: [freetds] Need your help.
  • Date: Thu, 31 Dec 2009 06:58:47 -0500

Sandeep:



According the FAQ located at ( http://freetds.org/faq.html#encrypted )

"Encrypted connections to Microsoft SQL Server 2008 using FreeTDS 0.82 do
not work. Avoid them!"



Paul







-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
sandeep.poojary AT wipro.com
Sent: Thursday, December 31, 2009 6:50 AM
To: freetds AT lists.ibiblio.org; a_wake AT earthlink.net
Subject: [freetds] Need your help.



Hi Team,



Need your help...





Server Details:



Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009

10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard

Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)





We have installed Certificate on MSSQL 2008 Server ( above is the server

details)



Currently backup jobs running with the sql server authentication.





after the installation of ssl , whenever we tries to connect sql server

we get below error.



Error:



2009-12-30 18:46:56.160 Logon Error: 17835, Severity: 20, State: 1.

2009-12-30 18:46:56.160 Logon Encryption is required to connect to

this server but the client library does not support encryption; the

connection has been closed. Please upgrade your client library. [CLIENT:

169.180.200.186]





Regards,

Sandeep Poojary



-----Original Message-----

From: freetds-bounces AT lists.ibiblio.org

[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Paul Thurston

Sent: Thursday, December 31, 2009 5:00 PM

To: a_wake AT earthlink.net; 'FreeTDS Development Group'

Subject: Re: [freetds] Using freetds in Windows



Andrew:







On Windows, if your using v0.82, you'll need to set the environment

variable FREETDSCONF to point to your freetds.conf file.



Also, remember to escape the file path sequence as follows: SET

FREETDSCONF=C:\\Apps\\FreeTDS\\etc\\freetds.conf



In the freetds.con file itself, make sure that line host=<Address> is a

valid IP address to the database server.







Paul



















-----Original Message-----

From: freetds-bounces AT lists.ibiblio.org

[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Andrew H.

Wakefield

Sent: Thursday, December 31, 2009 12:15 AM

To: freetds AT lists.ibiblio.org

Subject: [freetds] Using freetds in Windows







I have successfully cross-compiled freetds-0.82 for Windows. I can use



the resulting tsql.exe with an explicit host and port (e.g., tsql -H



127.0.0.1 -p 1433 -U username) and connect to the SQL Server. However, I



cannot seem to find a way to use a server name (e.g., tsql -S SQLEXPRESS



-U username). In Linux, I put the server information into the



freetds.conf file and it works fine. I have tried putting the server



information into freetds.conf and .freetds.conf in the MS-DOS directory



where tsql.exe is running; I have tried setting the environment variable



FREETDS to point to this file. Nothing has worked. Help!







_______________________________________________



FreeTDS mailing list



FreeTDS AT lists.ibiblio.org



http://lists.ibiblio.org/mailman/listinfo/freetds



_______________________________________________

FreeTDS mailing list

FreeTDS AT lists.ibiblio.org

http://lists.ibiblio.org/mailman/listinfo/freetds



Please do not print this email unless it is absolutely necessary.



The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.



WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.



www.wipro.com

_______________________________________________

FreeTDS mailing list

FreeTDS AT lists.ibiblio.org

http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page