Home Forums SQL Server 2005 T-SQL (SS2K5) OPENROWSET Trusted_Connection Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' RE: OPENROWSET Trusted_Connection Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  • Are all of the server startup services starting up with the same login, and what is the level of permissino for this login. We have over 200 servers talking amongst themselves this way. The startup service is a Domain Admin account and a sysadmin on each of the servers. In this configuration, the only issue we have has is when a DNS issue arises.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan