Re: beginers encryption question

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/29/03

  • Next message: Dani: "Windows Only vs. SQL Server and Windows Auth."
    Date: Fri, 29 Aug 2003 16:16:07 +0100
    
    

    >If I the set client network utility to use encrytion on
    >the web server, do I have to do anything at the sql
    >server?

    Yes, you have to install a certificate to be used for the encryption

    HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
    http://support.microsoft.com/?id=276553

    >If I change the Server network utitly to use encrytion,
    >will all clients have to use encrytion, not just the web
    >server?

    Yes all connections would be encrypted if enforced using the Server Network
    Utility on the SQL Server

    -- 
    HTH
    Jasper Smith (SQL Server MVP)
    I support PASS - the definitive, global
    community for SQL Server professionals -
    http://www.sqlpass.org
    "John" <felix.hedey@hotmail.com> wrote in message
    news:091701c36e19$0b1e9fe0$a601280a@phx.gbl...
    What I want to do is encryt all informatiom sent from a
    web server to a sql server.
    If I the set client network utility  to use encrytion on
    the web server, do I have to do anything at the  sql
    server?
    If I change the  Server network utitly to use encrytion,
    will all clients have to use encrytion, not just the web
    server?
    

  • Next message: Dani: "Windows Only vs. SQL Server and Windows Auth."

    Relevant Pages

    • Re: SQLServer Connection Problems...
      ... making it all the way to SQL but its failing at the SQL login. ... Only take this step if your server is protected inside a good firewall... ... Most good judgment comes from experience. ... I can ping the SBS server from the Web Server on a local ip address ...
      (microsoft.public.sqlserver.connect)
    • Re: Using Access to access an sql database on a webserver
      ... a open sql port is not available. ... that very same web server has complete and free rein to access those files, ... Well, yes, if you are taking about ASP pages hosted on that site...right? ...
      (comp.databases.ms-access)
    • RE: Fulltext failure on a 2 node cluster
      ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
      (microsoft.public.sqlserver.clustering)
    • Re: HELP PLEASE ~ ???
      ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)