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