Competition: What’s your favorite Redgate tool? Enter now.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' in baseline script

markoos120markoos120 Posts: 3 New member
edited July 26, 2018 6:21PM in SQL Change Automation
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
Tagged:

Answers

Sign In or Register to comment.