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

[Mark Rae]

"alexmaster_2004" <al************@discussions.microsoft.com> wrote in
message news:CA**********************************@microsof t.com...

PLEASE i need anyone to help me change my code so that the webservice can
access the database server without uisng trusted connection.

http://www.connectionstrings.com/

[Octavio Hernandez]

Hi,

You only need to remove the 'Integrated Security=SSPI' from you connection
string and add 'User Id=xxxx;Password=yyyy'.

Regards - Octavio

"alexmaster_2004" <al************@discussions.microsoft.com> escribió en el
mensaje news:CA**********************************@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