Hi all,
I’m running through a simple SQL server web application and I get an error message that reads:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'COCLAP-9\ASPNET'.

Here is my connection string:

Dim objConnection As New SqlClient.SqlConnection _
("server=COCLAP-9\VSDOTNET;database=LOTR;trusted_connection=true")

As you can see, the connection string reads COCLAP-9\VSDOTNET (and not 'COCLAP-9\ASPNET' as in the error message - Hhmm ). When I created the database I left the ‘Use Windows NT Integrated Security’ option button checked.

My server name is COCLAP-9 and the database name is LOTR. Which are correct in the connection string

when I run the application it shows the Default.aspx page as expected but as soon as I try to Open to the database, withthis line objConnection.Open() I get the error message.

I can’t see anything wrong here, can you?
Why do I need to login on a simple database application?

Any ideas?

Thanks for your time