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 "
Steve Jones - SSC Editor
SSC Guru
Points: 734418
More actions
March 22, 2008 at 10:58 am
#792825
You need to check the linked server credentials to see what's there. You can either have set credentials for everyone, rights for some people and not others, or pass through credentials.
Check in SSMS how the linked server security is configured.