Home Forums SQL Server 2005 SQL Server 2005 Security "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn " RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

  • He's avoiding the double-hop issue by switching the security context. Previously you were doing this:

    client -> web server (as Windows user) -> SQL Server (as Windows user)

    now you're doing this:

    client -> web server (as Windows user) -> SQL Server (as SQL Server login)

    K. Brian Kelley
    @kbriankelley