How can we help you today? How can we help you today?

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

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
0

Comments

2 comments

Sort by
  • markoos120
    Update: seems like this is reproducible simply by running the script via sqlcmd...so possibly this is the root cause.
    markoos120
    0
  • Ivo_Miller
    SQL Change Automation executes scripts using sqlcmd, so it definitely sounds like that is the source of the issue.
    Ivo_Miller
    0

Add comment

Please sign in to leave a comment.