Login failed for user ' '. The user is not associated with a trusted SQL Server connection.

What does your connection string look like?  You can remove any sensitive information before you post it.

To change the authentication mode from Windows Authentication to Mixed Mode, use either of the following steps:

Using the Database Maintenance Wizard:
1.) Select 'Switch Server Security Mode'
2.) Choose the correct SQL server and database if necessary
3.) Specify the option for 'SQL Server and Windows'
4.) Click 'Next', then 'Finish'
5.) Restart SQL Server in order for the change to take effect.

OR

Using the SQL Enterprise Manager:
1.) Expand a Server group.
2.) Right-click a server name, and then click Properties.
3.) Click the Security tab.
4.) Under Authentication, click the SQL Server and Windows option button.
5.) Restart SQL Server in order for the change to take effect.


Ref: http://www.scriptlogic.com/support/kb/displayarticle.asp?UID=564

thanks for the replies,

Here is my connection string from web config.

<add name="LoansConnectionString" connectionString="Data Source=SQLDEV2;Initial Catalog=Loans;Integrated Security=True"
   providerName="System.Data.SqlClient" />

ryancys: mixed mode was already enabled, I had been able to logon in debug mode until I uninstalled reinstalled  server extensions 2002

Check this out:
http://www.carlprothman.net/Default.aspx?tabid=86#SQLClientManagedProvider

this section:

Using VB.NET:

    Imports System.Data.SqlClient
    ...
    Dim oSQLConn As SqlConnection = New SqlConnection()
    oSQLConn.ConnectionString = _
        "Data Source=(local);" & _
        "Initial Catalog=myDatabaseName;" & _
        "Integrated Security=SSPI"
    oSQLConn.Open()

is more or less what I have except integrated security = true not 'SSPI'

I'm guessing you're trying to use a trusted connection user. Make sure the user you want to connect to the database with is the anonymous user in IIS and that that user can log into the database and has appropriate permissions. In you web.config in the <system.web></system.web> section add the tag <identity impersonate="true" /> this tells .Net to run under the context of the anonymous user.

http://idunno.org/articles/276.aspx 

Hi crisco96 thanks for the suggestion unfortunately it made no difference.

"Make sure the user you want to connect to the database with is the anonymous user in IIS and that that user can log into the database and has appropriate permissions."

How can I tell if its the anonymous user in IIS that I'm using? and that he has permissons?  

The error msg says "Login failed for user ' '. " there is not a username between the ' '

I should have said, both sqlserver 2005 and IIS are running on the same server.

First did you put the <identity impersonate="true" /> tag in your system.web section in your web.config? And are you using .net 2.0?

Yes to...
"did you put the <identity impersonate="true" /> tag in your system.web section in your web.config"
Version
asp.net 2.0

I am now getting this error .. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'SQLDEV2\IUSR_SQLDEV2'.

when I try to logon

This site is supposed to use the NETWORK SERVICE for all access to db

Thanks.