Secure Connection to SQL Server 2000 Database

From: AF (anonymous_at_discussions.microsoft.com)
Date: 06/04/04


Date: Fri, 4 Jun 2004 11:31:04 -0700

I am looking for the options in securing this connection.

First option tried:

A certificate was installed on the remote server and the option "encrypt=true" added to the connection string, but still getting an SSL error (works without the encrypt option). What else must be configured for this to work properly? Is this the most straightforward way to encrypt all data to and from the webserver?

Any help or examples would be appreciated.

Thank you,
AF

Environment

Web Server:
Windows 2k Server
IIS 5
ASP.NET Web Application

Database Server
Windows 2k Server
SQL Server 2000



Relevant Pages

  • Re: server authentication & ASP authentication
    ... The SQL Server and web server are on the same machine (Windows 2000). ... Use windows instead of standard authentication on SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: 401.2 Error
    ... logged on the web server but when the user tries to logon ... >Does that mean you are expecting a password prompt? ... >> The web server is publicly available although he has the ... He is using Windows XP ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: 401.2 Error
    ... logged on the web server but when the user tries to logon ... >Does that mean you are expecting a password prompt? ... >> The web server is publicly available although he has the ... He is using Windows XP ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Where to run the Certificate Services to be an Enterprise CA
    ... We have Windows 2000 Domain controllers, file servers, and a Web server. ... a Windows 2003 Web server running Windows Sharepoint Services and Project Server, ...
    (microsoft.public.windows.server.security)
  • Where to run the Certificate Services to be an Enterprise CA
    ... We have Windows 2000 Domain controllers, file servers, and a Web server. ... a Windows 2003 Web server running Windows Sharepoint Services and Project Server, ...
    (microsoft.public.windows.server.security)