I am using a OLEDB connection
I login to the server(which has IIS installed) using a userid "ABC" and my sql server database login is "XYZ"
and when I request my asp.net webpage in browser I get a an error which is
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'