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

markoos120

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

markoos120

Update: seems like this is reproducible simply by running the script via sqlcmd...so possibly this is the root cause.

Ivo_Miller

SQL Change Automation executes scripts using sqlcmd, so it definitely sounds like that is the source of the issue.