Hi Bonnie,
Installed vs2003 on a box which had nothing other than XP and SQLserver. Created a very simple web service and it failed with the infamous message:
System.Data.SqlClient.SqlException: Login failed for user 'CETIN\ASPNET'.
Granting ASPNET account it worked.
Cetin
>Cetin,
>
>
>I believe you remember it wrong - at least hope that you do>
>That could be ... this old brain ain't what it used to be! <g>
>
>
>If I can create a test box I'll test it>
>Please do ... I looked up and down and all around and could not find anything anywhere that indicated I had set up any additional security. At least not in SQL Server. Maybe there was some other setting somewhere, machine.config or something maybe? I still don't know, I didn't see anything obvious elsewhere either.
>
>~~Bonnie
>
>
>
>
>
>
>>Bonnie,
>>I believe you remember it wrong - at least hope that you do. Otherwise it means a security hole in SQL server. If I can create a test box I'll test it and hopefully will not work.
>>Cetin
>>
>>
>>>Cetin,
>>>
>>>
>However one thing is different between IIS versions.>>>
>>>I'm using IIS 5.
>>>
>>>
>I suspect in 1.1 you either were not using anoymous user or had UID/PWD. In config impersonate = true might have effect too. I didn't use impersonation.>>>
>>>Anonymous Access was enabled.
>>>Not using Impersonation.
>>>No UID/PWD (why would I have that when I'm testing the Trusted_Connection? <g>)
>>>
>>>~~Bonnie