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

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: SSIS as part of scheduled job fails
    ... An SSIS package does not run when you call the SSIS package from a SQL ... Microsoft SQL Server Management Studio ... I ended up contacting Microsoft and opening a support case. ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Express Edition Network Deployment Error
    ... I have instructed my colleague to ask for a quotation of MS SQL Standard to solve our problem. ... There is a 25% Discount on SQL Server up to Sept this year. ... Because your mdf is located in a network share and our app accesses the mdf ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Cant con
    ... cannot open SQL Enterprise Manager. ... From the error message, it seems to be related to SSL and certifcate. ... Edit the registry on the SQL Server machine and make the following ...
    (microsoft.public.sqlserver.connect)
  • RE: SSMSE vs. SSMS
    ... Yes, from the following article in SQL Server 2005 BOL, I think that you ... SSMSE cannot manage Analysis Services, Integration Services, Notification ... SSMSE does not support scheduling administrative tasks by using SQL ...
    (microsoft.public.sqlserver.clients)