My question is also same, however I am trying to configure SSL on SQL Server
2000,
1-SQL Server OS is Windows 2003 Server, SQL Server 2000 with SP 4, Active
directory is also installed on same machine, this is test system a AD domain
trust relationship is configured with the production domain).
2- I create and configure the certificate successfully, (MS CA was also
installed on the same machine, Server Authentication certificate was issued
by this CA, however I removed CA's private key from server).
3- I enabled "Force Protocol Encryption" option, (at this point I have a
question that is "how can I make it sure either SQL Server SSL configured
successfully", is there any utility / mechanism to verify SSL
configuration?)
4- Using SQL 2005 Management studio/ SQL Server 2000 Client (from other
machines joined to production domain controller), connection to server is
OK, (I have no idea either it is SSL or Non-SSL, please note it that "Force
Encrypted Connection" option in SQL Server 2000 network utility is enabled,
so I am sure SQL Server 2005 management studio is working behind SQL Server
using SSL).
5- But when I tried to communicate to the same server from same machines
using JDBC connectivity, I am failed to connect to SQL Server 2000 databases
I receive the error messages in SQL log as below
"Connection opened but invalid login packet(s) sent. Connection
closed.."
"Error: 17832, Severity: 20, State: 9"
I am using Sprinta Type 4 driver for JDBC connectivity.
Thank you in advance.
Best Regards,
Atiq Ur Rahman Chaudhary
IT Manager
> Hi ,
>
[quoted text clipped - 8 lines]
>
> Thanks to you all genious in advance !!