Now you confused me - why I did need to add it in 1.1 too:)
Cetin
>Yes, I'm certain I never had to add anything when using Trusted Connection with 1.1.
>
>Before I found out that I had to add those rights to SQL Server for 2.0 to work correctly, it had worked fine with 1.1 ... that was why I was so frustrated that it didn't work the same for 2.0.
>
>~~Bonnie
>
>
>
>
>>Bonnie,
>>Are you sure 1.1 didn't need anything? I remember I always had to do that. You might try with 1.1 first removing ASPNet's rights from SQL server.
>>Cetin
>>
>>>Cetin,
>>>
>>>
>It works for me when I give machineName\ASPNet account >>>
>>>Yes, that's what I found out that I had to do, but I never had to do that with 1.1. It just worked with no permission settings that I ever had to add.
>>>
>>>~~Bonnie
>>>
>>>
>>>
>>>
>>>>John,
>>>>It works for me when I give machineName\ASPNet account (or NT Authority\Network service under win2003) access to my SQL server (as it did before with vs2003). Probably in IIS anonymous is not allowed).
>>>>Cetin
>>>>
>>>>>Did you ever figure this one out. I'm curious about the result.
>>>>>
>>>>>
>>>>>>I'm sure this is a known problem, but I can't seem to find the fix.
>>>>>>
>>>>>>My VS2005 app connects to the SQL Server database through web services. If I connect with a connection string that uses userid and password, no problem. But, if I change that to use a Trusted_Connection instead, it won't work.
>>>>>>
>>>>>>This worked fine when the app was compiled under VS2003, but has not since migrating it to VS2005. Is there some setting I need to tweak somewhere? In IIS maybe? This is only a problem with Web Services.
>>>>>>
>>>>>>TIA,
>>>>>>
>>>>>>~~Bonnie