Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc