Re: Need your help.

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: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Thursday, December 31, 2009 6:50 AM
To: [email protected]; [email protected]
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: [email protected]

[mailto:[email protected]] On Behalf Of Paul Thurston

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

To: [email protected]; '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: [email protected]

[mailto:[email protected]] On Behalf Of Andrew H.

Wakefield

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

To: [email protected]

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

 

[email protected]

 

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

 

_______________________________________________

FreeTDS mailing list

[email protected]

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

[email protected]

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