I can logon to our SQL 200 Server fine, and so can the applications. However,
when I try to modify this one stored procedure (and only the one proc), it
gives the following error:
"Server: Msg 18452, Level 14, State 1, Procedure XXXXXXX, Line 84
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
When I execute it using the exact same account on the local machine, it
My account is part of the Domain Admins group, and that group is a member of
the "System Administrators" role in SQL. This proc does some stuff with
linked servers, and I'm wondering if that might be the cause. It is also
considered a "heterogeneous query", if that helps.
The server is part of our domain, but not a domain controller. All machines
I tried executing it from also were on the domain.