Re: Security Certificates

From: Andrew Prior (andrew_at_ouremailaddress.com.au)
Date: 08/25/05

  • Next message: Sue Hoegemeier: "Re: Confysed by the roles" 
    Date: Thu, 25 Aug 2005 09:06:51 +0930

    Thankyou Mike.
    I've tried to follow the msdn article on our internal network as a test and
    it although I can issue certificates etc, I can not see that there is any
    effect. ie if I enforc encryption, it makes no difference to the client.

    The thing that puzzled me was the line in the article that says you need:
    "Two computers running the Microsoft Windows® 2000 Server operating system"
    I'm talking about XP Pro clients using Access Front ends that make the ODBC
    calls. Am I in the right paddock?

    Andrew

    "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
    news:A21D8343-AEE8-41BE-B3D5-F444C0260639@microsoft.com...
    > Hi
    >
    > You have to install the certificate on the server.
    > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT19.asp
    >
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;318605
    >
    > Regards
    > --------------------------------
    > Mike Epprecht, Microsoft SQL Server MVP
    > Zurich, Switzerland
    >
    > MVP Program: http://www.microsoft.com/mvp
    >
    > Blog: http://www.msmvps.com/epprecht/
    >
    >
    >
    > "Andrew Prior" wrote:
    >
    >> I'm out of my depth here.
    >> We need to have odbc encryption between an SQL server and some clients
    >> only.
    >> So that means security is required in the clients; I get that bit OK.
    >>
    >> All the stuff I am reading on security certificates seems to talk about
    >> IIS
    >> being used to set up the certificate.This is an SQL only server; ie IIS
    >> is
    >> turned off. Only ODBC calls are made to the server. How do I apply a
    >> certificate. The techs at the hosting company can't seem to help me.
    >> This
    >> is a remote server from me ie 600 miles so I am loathe to just try things
    >> on
    >> the offchance :-)
    >>
    >> Andrew
    >>
    >>
    >>

  • Next message: Sue Hoegemeier: "Re: Confysed by the roles"

    Relevant Pages

    • Re: Secure VPN access
      ... with it's security option for the client. ... After getting the VPN connection I check the Ip settings and found the ... point to the head ISP's DNS server. ... > Computer certificates for L2TP/IPSec VPN connections ...
      (microsoft.public.windows.server.sbs)
    • RE: L2TP/IPSEC site-to-site question
      ... seems more difficult on Windows and Isa 2000 mix, ... If I want to use certificates what type I have to use? ... > site-to-site VPN connection. ... > Site-to-Site VPN in ISA Server 2004 ...
      (microsoft.public.isa)
    • Re: Vista wireless using IAS and WPA-Enterprise
      ... certificates, which may be more than the limit that the IAS server can send ... on a Web site or if you use IAS in Windows Server 2003 ... Vista wireless using IAS and WPA-Enterprise ...
      (microsoft.public.windows.server.networking)
    • RE: L2TP/IPSEC site-to-site question
      ... Microsoft Internet Security and Acceleration (ISA) Server 2004 ... >site-to-site vpn connection. ... >My concerns are about the certificates part. ...
      (microsoft.public.isa)
    • Re: IAS EAP (PEAP)
      ... > IAS is registered with AD so I am okay there. ... If you create the server cert using the information below, ... Use this procedure to configure IAS server certificates for use with PEAP ...
      (microsoft.public.internet.radius)