Thanks a lot Fred. I'll give that a try tonight when I get home.

Thanks,
Pat Moran


>>Hello all,
>>
>>I am working with the "Visual Studio.Net for VFP Developers" book by Kevin McNeish.
>>
>>I have built the sample Windows Form application using the business objects and all works fine.
>>
>>Now I am attempting to build the ASP.Net application that uses these same business objects. I can get a simple web page to display fine. When I add code to the CustomerOrders.Aspx to instantiate the business objects, I receive this error after trying to retrieve a customer's orders:
>>
>>Login failed for user 'PATRICK-N8PI1HM\ASPNET'
>>
>>My SQL server is patrick-n8pi1hm but who is the ASPNET user? I thought that since the business object ovbiously work correctly with the Windows Form applcation, they would work with an ASP.Net application as well.
>>
>>Could the problem be IIS is not setup correctly?
>>
>>Thanks in advance for any help. I really lack experience with Web apps so any help would be greatly appreciated.
>>
>>Thanks,
>>Pat Moran
>
>ASP.NET is attenmpting to connect to SQL Server with user id ASPNET. ASPNET needs to be a user id in SQL SErver with rights to the database. The rights would depend on what you are attempting to do. For playing around, give ASPNET full rights to your test database.