Re: JDBC for SQL 2000 Service Pack 4?

The Microsof SQL Server 2000 Driver for JDBC does not support SSL
encryption.

There was an issue prior to Service Pack 4 for SQL Server 2000 where the
JDBC driver was able to connect to a SQL Server database even though the
"force protocol encryption" option was set on the server. The SQL Server
would incorrectly allow an unencrypted connection with the JDBC driver.

In Service Pack 4 for SQL Server 2000 this was fixed so that only clients
that support SSL can connect to the server if the "force protocol
encryption" option is set on the server. This will exclude the JDBC driver
since it does not support SSL and you will receive an error on the client.

Thanks,
Kamil


Kamil Sykora
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.


Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/secur­ity.



--------------------
| Date: Fri, 10 Jun 2005 10:34:59 -0400
| From: News <nooneherereally@xxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: Re: JDBC for SQL 2000 Service Pack 4?
|
| Alin Sinpalean wrote:
| > Anyone what?
| >
|
|
| Can someone confirm that the JDBC drivers (for sp3) can successfully
| connect to SQL Server w/ SP4 *when the "force protocol encryption"
| option is enabled*?
|

.

Relevant Pages

  • JDBC SP3 and SSL
    ... If I enable SSL on my SQL Server (using the Force Protocol Encryption in ... If the current version of Microsoft's JDBC ... connect to SQL Server and it has to use Microsoft's JDBC Driver in order to ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Setting Up Training Domain
    ... The connection string that you have posted is not a valid JDBC connection ... This newsgroup is concerned with issues surrounding the JDBC ... If you are not using the JDBC driver to connect to SQL Server then you may ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC Driver for SQL 2000 - Pls help
    ... > Compliant driver to connection to out SQL Server 2000 instance ... The Microsoft driver is only a JDBC 2.0 implementation and it has a ...
    (microsoft.public.sqlserver.server)
  • Re: JDBC 3.0?
    ... SQL Server is planning to ship an updated JDBC driver for the next version ... SQL Programming Model, SQL Server ... > I'm worried that Microsoft will eventually stop updating their 'free' JDBC ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... After checking with Microsoft it turns out that transmitting Unicode ... requires a change in the data format sent to the JDBC Receiver channel. ... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ...
    (microsoft.public.sqlserver.jdbcdriver)