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