MSDE is set up for Windows Authentication, 99.9% sure but there is an admin with a quick reaction to fix things here. A quick check from my desktop EM and yes it's set for WA.

I can do anything with the database from EM, QA, or even my .NET IDE Server Explorer. It's just when I change the sever name in :
string strConnection = "SERVER=STEPHEN-LAPTOP;Trusted_Connection=Yes ";
to
string strConnection = "SERVER=CHDIIS;Trusted_Connection=Yes ";
it fails with the error that is this subject.

__Stephen


>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