RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Can't con

Thanks, Peter, the export/delete/start/stop/import did the trick!
--
John Austin


"Peter Yang [MSFT]" wrote:

Hello John,

I understand that after you installed IE7 on WinXP pro sp2 machine, you
cannot open SQL Enterprise Manager. You received the error message about
SSL. If I'm off-base, please let me know.

From the error message, it seems to be related to SSL and certifcate. I
suggest that you temporarily disable SSL for SQL Server to isolate the
issue:

1. Start Server Network Utility.
2. In the Server Network Utility dialog box, click the General tab.
3. On the General tab, deselect Force protocol encryption, and click OK.
4. Start SQL client network utility,
5. On the General tab, deselect Force protocol encryption, and click OK.

If the issue persists, please try the following steps to disable the SSL
via registry change.

1. Edit the registry on the SQL Server machine and make the following
change (Admin privileges are needed on the server for this change):

For a Default Instance:
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib REG_SZ
Certificate = 0

For a Named Instance:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\instance
name\MSSQLServer\SuperSocketNetLib REG_SZ
Certificate = 0

2. Stop, and then start the SQL Server service.

If the issue does not occur at this time, please refer to the following
article to check the certificate is valid and/or use a different
certificate to test the situation.

309398 SQL Server 2000 installation or local connections fail with "SSL
Security error :ConnectionOpen (SECDoClientHandshake())" error message
http://support.microsoft.com/default.aspx?scid=kb;EN-US;309398

http://support.microsoft.com/default.aspx?scid=kb;[LN];316898
How to enable SSL encryption for an instance of SQL Server by using
Microsoft Management Console

If you have further questions on the issue, please feel free to let's know.
I look forward to your reply. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: SQL Adaptor - Timeout
    ... Anyway there is not many methods to throttling: ... SQL send port trying to repeat the SP several times then suspend the ... Server stored procedures using SQL Server Adaptor. ... The adapter "SQL" raised an error message. ...
    (microsoft.public.biztalk.general)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... The file that is attached to the "Open a Company" command is a text document that appears to just contain the connection string for the selected company. ... Server Express Edition locally, but cannot connect remotely, and if the SQL Server Express Edition is listening on Named Pipes, then I suspect a firewall issue on the computer that is running SQL Server Express Edition. ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Cant connect
    ... cannot open SQL Enterprise Manager. ... suggest that you temporarily disable SSL for SQL Server to isolate the ... Edit the registry on the SQL Server machine and make the following ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: installed ssl-certificate -> SQL-Server locked !
    ... Certificate issued to the FQDN name of the computer. ... This would be the same if you were to setup IIS for SSL using Server ... So, if IIS and SQL are on the same machine, ... Enable SSL Encryption for SQL Server 2000 with Certificate ...
    (microsoft.public.sqlserver.security)