connect to sql2000 server

[alexmaster_2004]

hi every one
i have made a webservice that access a sql2000 database server.
when i have devloped this webservice on my machine it was run correctly.
and it was use trusted connection to connect to the database server.
but when i had deployed it, it didn't worked due to the failure to connect
to the server uisng the ASPNET user account.when i have checked the server
configurations i have found that it is not allow to use trusted connection.
PLEASE i need anyone to help me change my code so that the webservice can
access the database server without uisng trusted connection.
Thanks

[Sam Santiago]

You can store a connection string in your web.config that specifies a user name and login. If you are concerned about having the password in clear text in the web config you can encrypt it and even store it in the registry if you wish. Check out this article:


How To Store an Encrypted Connection String in the Registry
http://msdn.microsoft.com/library/de...l/secmod25.asp

Thanks,

Sam

--
_______________________________
Sam Santiago
ss*******@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________
"alexmaster_2004" <al************@discussions.microsoft.com> wrote in message news:E8**********************************@microsof t.com...

hi every one
i have made a webservice that access a sql2000 database server.
when i have devloped this webservice on my machine it was run correctly.
and it was use trusted connection to connect to the database server.
but when i had deployed it, it didn't worked due to the failure to connect
to the server uisng the ASPNET user account.when i have checked the server
configurations i have found that it is not allow to use trusted connection.
PLEASE i need anyone to help me change my code so that the webservice can
access the database server without uisng trusted connection.
Thanks