SSL only works when ms sql server has "force encryption

SSL only works when ms sql server has "force encryption

Post by pigeo » Wed, 29 Jun 2005 14:35:59

SSL only works when ms sql server has "force encryption option"
turned on...

If I turn that off, and try to have the client software request
encryption.. I get a ssl security error msg.

The thing is.. I had this working before I upgraded to sp3andsp4and
install my new cert (I did the upgrades at the same time)

Any ideas?


Posted using the interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
Visit Topic URL to contact author (reg. req'd). Report abuse:

1. SSL Encryption for SQL Server 2000 through ISA Server 2004

2. SQL Server SSL Encryption with UNIX O/S

We use the ETL tool, Informatica PowerMart, which is client/server based. In general, the client (installed on Windows XP) is used to map the logical transformation processes of the data to be moved while the server (installed on a UNIX machine -O/S HP-UX 11i) runs the workflows to process the data. The problem encountered is with connectivity between the server and an encrypted SQL Server 2000 database installed on a Windows server.

We have no problems when importing the source and target definitions from the encrypted SQL Server database using the client application with the ODBC driver SQL Server (sqlsrv32.dll dated 10/27/03) since the clients are operating on a Windows operating system. However, since the server is on a UNIX O/S, we have to install and configure the ODBC drivers and connections on the UNIX box. Prior to encrypting the database, we had no problems connecting to the database from the server. However, after the database was placed in encrypted mode, we have been unable to connect using the Data Direct 4.10 SQL Server driver packaged with the PowerMart product. After thorough investigation, we have found that the Data Direct drivers do not support SSL encryption.

Does anyone know where we might find an ODBC driver that we might install, on our UNIX server to connect to SQL Server 2000 database, that supports SSL encryption? The technical rep at Informatica indicated that the Data Direct drivers were created in the C++ language and that we need to find a driver that supports SSL encryption for installation on the server. We have a couple of critical development projects that are depending on the tool and I hope to find a driver or alternative solution soon.


3. Error when using SSL encryption for SQL server 2000

4. SQL Server SSL Encryption w/ UNIX O/S

5. SQL Server 2000 and SSL Encryption - Implementation Specifics need

6. Certificate for SSL encryption on a SQL Server cluster

7. Force Protocol Encryption on SQL Server

8. SQL Server 2005 - Force Encryption

9. Force Protocol Encryption Enabled & SQL Server Cannot Start

10. OWA SSL through ISA Server (works but having strange problem)

11. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

12. CPU usage changed after upgrading to MS SQL Server 2000 from MS SQL Server 6.5

13. best pratices for transferring MS SQL Server 7 database to MS SQL Server 2000

14. how to force ssl higher encryption

15. I cannot upgrade MS SQL Server 6.5 to MS SQL Server 2000