JDBC-SSL - MS SQL Server 2000 issue
- From: "Atiq UR Rahman Chaudhary" <atiq.rahman@xxxxxxxxxxxx>
- Date: Fri, 20 Jul 2007 13:06:52 +0500
I am trying to configure SSL on SQL Server 2000, see the steps that I
followed:
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
6- I found 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.
7- The Java Exception is as below "
Loading database information ...
Database Driver : com.inet.tds.TdsDriver
Connection URL : jdbc:inetdae7:dcore:1433?database=tfcsp_NA
File Path is : ../conf/jdbc.properties
URL : jdbc:inetdae7:dcore:1433?database=tfcsp_NA
java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server
sit
e or network at header (0)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.<init>(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
com.ascertia.database.dsn.ASC_DSNFrame.testConnection_jButton_actionP
erformed(ASC_DSNFrame.java:1122)
at
com.ascertia.database.dsn.ASC_DSNFrame$5.actionPerformed(ASC_DSNFrame
..java:426)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
..java:420)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:236)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
31)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1778)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
J:\Program Files\bin>pause
Press any key to continue . . .
"
Your help is highly appriciated.
Best Regards
Atiq Ur Rahman Chaudhary
IT Manager
.
- Prev by Date: Re: JDBC - MSQL 2K5/MS SQL 2005 SSL ISSUE
- Next by Date: Custom Auditing
- Previous by thread: Re: user to execute nothing but SP in 2005
- Next by thread: Custom Auditing
- Index(es):