Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' in baseline script
markoos120
Posts: 3 New member
We're trying to setup a SCA project's database baseline script. In this script, there are some stored procedures that reference tables over linked servers. These procedures will fail with the error - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
The weird part is that if I run the script directly, in visual studio, against SQL Server, it works fine. Only when run from the SCA "refresh" button does this happen.
Is this possibly a double-hop issue? Distributed transaction issue? Or potentially something else? Anyone else have this and determine a workaround?
Thanks
The weird part is that if I run the script directly, in visual studio, against SQL Server, it works fine. Only when run from the SCA "refresh" button does this happen.
Is this possibly a double-hop issue? Distributed transaction issue? Or potentially something else? Anyone else have this and determine a workaround?
Thanks
Tagged:
Answers
RedGate Software Developer