"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Posted on 2006-06-09
Im building an ASP.Net page in VB.Net 2005.
In my solution I have included the web project and a db functions component that handles all database requests.
On load the page instantiates the db functions component and executes a function that retrieves data from the database.
I have set up the default security under IIS to run under a user account that I kbow has dbowner permissions on the databse.
When I run the project I get the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
how can I set up IIS so the page and the subsequent calls to other components run under the context of the use setup on IIS?
Thank you for any help in this regard.