I Changed the connection string in my code to disable annonomys access and use Trusted_Connection instead..
Hence i changed the following Connection string :
[global::System.Configuration.DefaultSettingValueAttribute("server=NICEDEV1;user id = NICEPLANDEV; password=****; database=NICEContacts")]
the reason I did this is because i need to be able to know the identity of the user logging in so that i can use this in Audit trail.. hence i can trace what each user has done in terms of changes and use this Machine authentication to Store his details against a row that is changed..
The problem is i get the following error when i use the second connection string..
The error is "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
I have even unchecked the enable Anonomys access option in IIS for this project..