Re: SSL connection Hangs SQL Server Service

From: Chris Chan (chris.chan@mindscope.com)
Date: 10/28/02 

From: "Chris Chan" <chris.chan@mindscope.com>
Date: Mon, 28 Oct 2002 07:22:46 -0800

Thank you very much for your reply. However, the KB
article problem has been resolved on SP2 and my SQL Server
had SP2 installed and the problem still appear. Here are
some more information...

The Setup
---------
On Server:
- SQL Server 2000 SP2 (The problem appears on BOTH
Standard Edition AND Developer Edition)
- Certificate with Server Authenication from a STAND ALONE
CA
- SQL Server Network Utility -> Force protocol encryption -
 NOT turn on

On Client:
- VB application
- ADO Connection with Use Encryption for Data (MDAC 2.6/
MDAC 2.7)
- Certificate with client Authenication from the same
STAND ALONE CA
- Client Network Utility -> Force protocol encryption -
NOT turn on

The problem
-----------
- SQL Server Service stop responding once in a while

- the service need to stop and restart for any other action

MORE INFO
---------
- Client Applications working properly under SSL encryption

- Could not find any pattern to cause the Server to hang.

- It could be hanging under couple connections or it could
be working under hundereds of connections

- If disable all the client applications not to use
encryption, then SQL server is stable

Thank you.

>-----Original Message-----
>Any additional info could be useful... See if this KB
article applies:
>
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q312948
>
>
>--
>Svyatoslav Pidgorny, MS MVP, MCSE
>-= F1 is the key =-
>
>"Chris Chan" <chris.chan@mindscope.com> wrote in message
>news:d21101c27b82$280730c0$3aef2ecf@TKMSFTNGXA09...
>> Could anyone help me out with this problem please?
>>
>> I am a developer of a VB application. The product is
based
>> on SQL Server and the application connect to SQL Server
>> thru ADO connections. The application is proven to be
>> working for years until I set up the program to use
>> Encryption for Data (SSL connection). The program could
>> connect to the server using SSL connections fine.
However,
>> SQL Server hangs or stop responding once in while and
the
>> SQL server service need to stop and restart. If no user
>> use encrypted connection then no problem. Any
suggestions?
>
>
>.
>

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... connections need to be returned to the pool to be ... Enterprise version of SQL Server 2000. ... server user login to be sure that it is not mixed with other running clients). ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... communication between ODBC (OLEDB and Native Client, ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)