Can you access the database from the designer? Is MSDE setup for Windows authentication or Mixed?
>Cathi, I have done those and no go. Seems that I am getting a machinename\ASPNET comming in as the user.
>
>Does this ring a bell for a fix?
>
>>Stephen,
>>
>>Make sure ASPNET has been added to MSDE as a user with sufficient rights.
>>
>>>I have a trusted connection SQL Server security inplace on both my laptop and the MSDE that I put up on a clients test server. When I run from my laptop things are good. When I try to use the identical data from his server I get an error:
>>>
>>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
>>>
>>>I am part of the domain and I have rights. I had an admin create an account for ASPNET, and I placed it in the server list of users. Gave it dbo rights and still no go.
>>>
>>>Any ideas on this security thing?
>>>
>>>TIA
>>>
>>>__Stephen
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi