Sql Server Programming :: Strange Connectivity Error


	Strange Connectivity Error 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 Server connection." When I execute it using the exact same account on the local machine, it works fine. 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. What is on line 84? -- Peter DeBetta, MVP - SQL Server http://sqlblog.com -- "Jeremy" <Jer@discussions.microsoft.com> wrote in message news:09DEC6D5-2CA3-4E4C-94E0-BCEBA4393A19@microsoft.com... - Hide quoted text - >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 > Server connection." > When I execute it using the exact same account on the local machine, it > works fine. > 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.