I have made a project with a lot of forms. At home when I configured the data adapter the page runs fine. Let the name of the page here be "Page1.aspx". In my connection string I am using workstation id as localhost and data source as "(local)" so when I transfer it to another computer it should not give problem. I transfered the whole project to my work place here I reconfigured the data adapter and generated the dataset with the same workstation id and data source. Now when I run "Page1.aspx" at office computer it gives an error saying login failed for (sqlservername/ASPNET).

This was the same error I was getting even at home when I made "Page2.aspx" and executed it. I thought maybe it was because of memory overload but now i am not sure. Can anyone help me solve this problem. If possible please also explain me why its happening and how to avoid it in the future. Thanks a lot