Great reference - thank you!
Tom
>Take a look at Chapter 12 - Data Access Security of Building Secure Microsoft ASP .NET Applications
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp>
>-Mike
>
>
>>Thanks for the reply. I will try these options you suggested.
>>
>>I think this is strange that my WinForm can query this MSDE table(s) but my WebForm can't.
>>
>>Another strange thing is that both my WinForm and WebForm can query a VFP table in a VFP database.
>>
>>Also, both the MSDE database and VFP database reside on my local drive.
>>
>>Could this be a setting in MSDE? How can I change this?
>>
>>More suggest are welcome.
>>
>>Thanks,
>>
>>Jerry
>>
>>
>>
>>
>>>>I have a SQL Server database residing on my PC. I can successfully query tables in this database from a .Net WinForm. However, if I attempt to perform the same queries using a .Net WebForm, I get the following error message:
>>>>
>>>>--------------
>>>>Server Error in '/myappfolder' Application.
>>>>Login failed for user 'Mydomain\Userid'.
>>>>--------------
>>>>
>>>>Why can I query the SQL Server tables within a WinForm but not within a WebForm?
>>>>
>>>>What can I do to correct this problem?
>>>>
>>>>Thanks,
>>>>
>>>>Jerry
>>>
>>>Jerry;
>>>
>>>Winforms and Webforms are different animals! :)
>>>
>>>Here is something I created after resolving the issues below. There are many types of security and this is only one - perhaps not the "best". I hope something here helps you.
>>>
>>>
ASP NET Login Issues for anonymous users>>>
>>>Problem:
>>>
>>>Error message – Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.
>>>
>>>Reason:
>>>
>>>IIS not set correctly
>>>
>>>Resolution:
>>>
>>>1. Open IIS
>>>2. Go to Default Web Site
>>>3. Right Click on Web Project of interest
>>>4. Select Properties
>>>5. Select Directory Security
>>>6. Go to “Anonymous access and authentication control”
>>>7. Select “Edit”
>>>8. Uncheck “Anonymous access”
>>>9. Select OK
>>>10. Select Apply
>>>11. Select OK
>>>
>>>Problem:
>>>
>>>Error message – Login failed for user ‘(null)’. Reason”: Not associated with a trusted SQL Server connection.
>>>
>>>Reason:
>>>
>>>IIS and/or Web.config may not be set correctly
>>>
>>>Resolution:
>>>
>>>See above to set IIS.
>>>
>>>In the Web.config file add the following line after the <system.web> tag and before the </system> end tag
>>>
>>><identity impersonate = "true"/>
>>>
>>>
>>>Tom