The connection string to the ASPNETDB is working - the one with the members and roles no problems. However, I am struggling to get into any of my pages that are connected to the websites database. (The second connection string).

I also have inherited a new annoying problem whereby when I first enter the website a WINDOWS SECURITY pop up appears asking for my credentials, which won't accept my credentials but oddly when I choose cancel it directs to my log in page that does...

Note, before adding the memberships I could get in fine but now when I remove the memberships I still draw the same error. Log In Failed....

Here is full error which I get no matter which of the pages I am accessing - note that not all of them have the databind error as this is obviously related to the fact that this page has a gridview. Some of them have tables and I cannot get into them either.