Query remote server



hi,

i have 2 sql2005 servers.
i am traying to drop , insert from one server to another,
and when i am trying to run simple query , i getting
an error:

"Msg 18452, Level 14, State 1, Line 1
Login failed for user ''. The user is not associated with a trusted SQL
Server connection."

the servers are configuerd to mix mode,i configure link server between the
two servers, but steel i am geating the same error.

yuval.


.



Relevant Pages

  • Re: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... [edit query statement/Criteria] ... Add computers you don't want to show up in Collection B ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... will see if I can't just send you the collection queries and the query ...
    (microsoft.public.sms.admin)
  • Re: router causing strange DNS behaviour?
    ... These cobbled together ISP networks can ... Initial query took about 4.5 secs ... Rogers is a Canadian ISP, and their name servers should have ...
    (comp.os.linux.networking)
  • Re: Boolean query algorithms
    ... Does that mean the query is broken up into 2 processes that are ... also my question relates to how said queries be them sql ... Google use 'chunck servers'. ... any of the 10 chunck servers that hold each chunk of data. ...
    (alt.internet.search-engines)
  • Re: 550 5.7.1 NDR caused by Exchange using A record instead of MX
    ... Thanks for the RFC reference David. ... If that initial mx query ... Mail servers are so touchy anymore because of SPAM that servers ... > Exchange is required to query the A record if no MX records exist. ...
    (microsoft.public.exchange.connectivity)