Re: ADO.NET security in Windows App?

From: Rob R. Ainscough (robains_at_pacbell.net)
Date: 06/28/05

  • Next message: Jose: "Decryption, cookies - "Bad Data"" 
    Date: Tue, 28 Jun 2005 08:12:51 -0700

    So do I specify in my connection string "Integrated Security=SSL" ?

    As usual, my MSDN search provides a bunch of information not relevant to my
    search criteria -- MSDN is becoming more more useless -- I get better search
    hit using Google -- frustrating.

    "Dominick Baier [DevelopMentor]" <dbaier@pleasepleasenospamdevelop.com>
    wrote in message news:523796632555552049163721@news.microsoft.com...
    > Hello Rob,
    >
    > SQL communication is clear text. This includes the initial password in the
    > connection string as well as all data you send between client/server.
    >
    > You have two options if you want to secure the data
    >
    > - IPSec tunnel between the two parties
    > - Enable SSL in SQL Server
    >
    > ---------------------------------------
    > Dominick Baier - DevelopMentor
    > http://www.leastprivilege.com
    >
    >> I've coded a VB.NET windows service that uses ADO.NET to communicate
    >> with both a MS Access database and an MS SQL Server 2000 database.
    >> I'm using SQL Authentication to validate access, but I'm not sure what
    >> options I have (if any) to secure the data transmission/communicate
    >> between my Windows Service and the SQL Server.
    >>
    >> I know with my web apps I can uses SSL, but what about standard .NET
    >> Windows apps -- do I have anyway to secure the data transmission
    >> to/from the SQL Server?
    >>
    >> Thanks,
    >>
    >
    >
    >

  • Next message: Jose: "Decryption, cookies - "Bad Data""

    Relevant Pages

    • Re: Data Shaping in VB6
      ... Public Function GetShapeConnection ... ' return a connection string to open a shaped recordset ... It works fine with a SQL Server ... or with an Access database under XP or NT. ...
      (microsoft.public.data.ado)
    • connect to Access DB via IP address
      ... Like SQL Server, is it possible to build the connection string using IP ... address for retrieving data from Access DB? ... of using VPN is the only solution to connect Access database in data center. ...
      (microsoft.public.dotnet.framework.adonet)
    • Help! Microsoft Access 2003 issue with linked tables.
      ... I have a Microsoft Access database and tables are linked to the SQL Server ... I use that SQL user in my connection string, ...
      (microsoft.public.access.security)
    • DataView with Microsoft Access
      ... I can insert a dataview and configure SQL Server with no problems, ... The access Database is on the server, ... The connection string I am using is: ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: One Connection String for Multiple Users (SQL)
      ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
      (microsoft.public.sqlserver.connect)