Re: SQL Server and ODBC connection strings question

In this connection string, you are setting the
authentication 3 times and using two different
authentication methods.
If you wan to connect with Windows authentication, you would
use trusted_connection OR integrated security. They do the
same thing. If you are going to use windows authentication,
don't include a user name a password.
So you should have either trusted_connection, integrated
security or supply a user and password. Just one of the
three - you are using all three.
If you are using Windows authentication, there is no
password being sent across the network.

-Sue

On Tue, 2 May 2006 19:28:01 -0700, SteveS
<SteveS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a connection string I use in a communication program I have created
and I'm curious about something.

Here is the string I use:
connection-string="Driver={SQL
Server};Server=localhost;Database=MyDatabase;Uid=MyName;Pwd=MyPassword;trusted_connection=yes;Integrated Security=SSPI;"

Is it possible to encrypt the password? If I'm using Integrated Security,
is the password still transmitted as clear text? My ultimate goal is to get
the entire string encrypted before it's sent over the wire to connect to the
DB (if not the entire string, I'd really like to NOT have the password set in
clear text). Is this possible - and if so, how?

Thanks,

.

Relevant Pages

  • Re: web server database access problem
    ... Are you using windows authentication or SQL ... authentication to access SQL server? ... Problem lies in IIS I think. ... >> in the connection string to make this work. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Web Service invoke as NT User
    ... Public Function GetCurrentUserEmail() As String ... You want it to run as the user issuing the web service call. ... do you have the directory security set up for Windows Authentication only. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Error 401: Unauthorized
    ... the application requires Windows authentication. ... I have full control ... > Private Function readHtmlPage(ByVal url As String) As String ...
    (microsoft.public.dotnet.general)
  • Re: Error 401: Unauthorized
    ... the application requires Windows authentication. ... I have full control of ... > The following snippet of code is part of a larger module, ... > Private Function readHtmlPage(ByVal url As String) As String ...
    (microsoft.public.dotnet.general)
  • WebSite Administration Tool
    ... I have been trying to set up a Webstie Administration Tool - Virtual ... Directory and have hit a couple of issues! ... I have set the site up as Integrated security and access the pages through ... All seems to be fine except the site says it is using Windows authentication ...
    (microsoft.public.dotnet.framework.aspnet.security)