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 "

  • Connections are made using the login's current security context.

    So in the following query, the login running the query is the same account in whose context the connection is attempted:

    SELECT * from [server\instance2k].dbName.dbo.tblName;

    The puzzling thing is that the same user is able to connect to instance server\instance2k through SSMS, while logged on the instance hosting the linked server.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]