(local.computer)\ASPNET.... User Authentication Failed

 Even though my connection string reads as follows:

"server=mycomp\sqlexpress;uid=myuser;pwd=mypw;Trusted_Connection=yes;database=communityserver" 

 

I am receiving the following error:

Cannot open database "communityserver" requested by the login. The login failed.
Login failed for user 'mycomp\ASPNET'.

 

Why is it attempting to run under the user 'ASPNET", rather than the specified "myuser"? Any help would be appreciated. 

You have set Trusted Connection=yes, meaning it will try to use Windows authentication, regardless of the userid and password you've defined. Change it to "no" and it will revert to using SQL authentication.

Great. That seems to work. However, it now supplies this error instead:

 

Procedure or Function 'aspnet_Profile_GetProperties' expects parameter '@TimeZoneAdjustment', which was not supplied.

 

Could this have something to do with this coinciding with my attempt to upgrade to CS 2.1? 

 

[ Edit: On second note, let me re-post this out of this thread because it no long relates to authentication ] 

Responded to this in your other thread...