Re: SQL Connection string.

From: Mary Chipman (mchip@nomail.please)
Date: 07/30/02 

From: Mary Chipman <mchip@nomail.please>
Date: Tue, 30 Jul 2002 11:37:43 -0400

Please do not cross-post the same message. asked and answered
elsewhere.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 29 Jul 2002 14:06:48 -0700, "Pankaj"
<pankaj.surti@compuware.com> wrote:

>Hi,
>
>As all of you know Web.Config file has the connection
>string for SQL Server. The problem is the password is
>plain text, it is visible to all who has access to
>Web.Config file.
>
>I know to Hash the password
>using 'FormsAuthentication.HashPasswordForStoringInConfigFi
>le'.
>
>My problem is how do I UnHash the password so that I can
>pass to SqlConnection.Open("") method.
>
>One solution is using System.Security.Cryptography.*
>classes.
>
>But I do not know where to look for it. Please help me.
>
>thanks,
>- Pankaj Surti.

Relevant Pages

  • Re: Cannot Generate SSPI Context - help
    ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
    (microsoft.public.inetserver.asp.db)
  • Re: Accessing an SQL Server database file
    ... Do you mind explaining to me how the connection string written their works? ... All systems have SQL Server Express and SQL Server 2005 installed. ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: ASP.NET 2.0 deployment (w/ SQL Srvr 2005) error
    ... The connection string was ok. ... than the SQL Server Instance, ... owningObject, SqlConnectionString connectionOptions, String ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Custom membership provider problem
    ... SQL server 2005 does not install with the TCP/IP protocol turned on. ... >An error has occurred while establishing a connection to the server. ... 25 - Connection string is not valid) ... >Boolean& failoverDemandDone, String host, String failoverPartner, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: ASP .Net connection to Sql Server
    ... Using "dbmssocn" tells it to use the TCP/IP network driver, ... It is connecting via a connection string similiar to: ... > string to our production SQL server and everything runs fine. ...
    (microsoft.public.dotnet.framework.aspnet)