mixed mode (SQL Server) and password in connection string

microsoft.public.dotnet.framework.adonet

18 Dec 2006 3:39 AM

R.A.M.

Hello,

I use mixed mode in my SQL Server 2005 Express Edition. I added connection
string to my web.config:

<add name="MIMProjekty"

connectionString="Data
Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
Catalog=MIMProjekty;uid=sa;pwd=sqlserver"

providerName="System.Data.SqlClient" />

The problem is that I do not want to have password visible. Could you tell
me please what to do? Thanks.

/RAM/

18 Dec 2006 7:56 AM

Miha Markic [MVP C#]

Hi,

Check out this article:
Keeping secrets in ASP.NET 2.0.
http://msdn.microsoft.com/msdnmag/issues/06/05/ExtremeASPNET/

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"R.A.M." <r_ahims***@poczta.onet.pl> wrote in message
news:em52i3$du3$1@news.onet.pl...
> Hello,
>
> I use mixed mode in my SQL Server 2005 Express Edition. I added connection
> string to my web.config:
>
> <add name="MIMProjekty"
>
> connectionString="Data
> Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
> Catalog=MIMProjekty;uid=sa;pwd=sqlserver"
>
> providerName="System.Data.SqlClient" />
>
> The problem is that I do not want to have password visible. Could you tell
> me please what to do? Thanks.
>
> /RAM/
>
>