authentication problem with MsSQL 2000 DB thru web service?

[jahchong]

Hi..

I'm not sure whether this question actually falls in this forum. Trying my luck anyways ...

I'm using VB .Net for writing a simle web service. I need to access an MsSql 2000 database. I have a login to my DB as user ASPNET and pwd aspnet.

First I placed the
<identity impersonate=&quot;false&quot; userName=&quot;ASPNET&quot; password=&quot;aspnet&quot;>

in my web.config file, and then set my login info in my connectionstring. I get the following error

Login failed for user 'MYPCNAME\ASPNET'

However, with <identity impersonate=&quot;true&quot;>
it works fine.

I must point out that I configured my web service thru IIS to have integrated windows authentication.

How can I get around this security problem?