Ok, Cetin .... and how did you grant the rights to the ASPNET account? Add a login to SQL Server with Enterprise Manager? I DID NOT HAVE a login to SQL Server for ASPNET prior to running into this problem with 2.0. I am 100% sure of that. I am also pretty sure that I didn't use impersonation (there's nothing in the web.config).
Maybe something in the machine.config? I'll have to look into that, because I can't remember what kind of stuff gets put into the machine.config (it's been so long since I had to do any configuration stuff <g>).
~~Bonnie
>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