"Chuck Heinzelman" wrote:
> It looks like you might be trying to connect using SQL Server authentication
> to a server that is only set up for Windows authentication.
>
> --
> Chuck Heinzelman - MCSD, MCDBA
> (Please respond only to the newsgroups.)
>
> I support the Professional Association for SQL Server and its community of
> SQL Server professionals.
>
www.sqlpass.org >
> "mporter" <mporter@discussions.microsoft.com> wrote in message
> news:18212398-03DE-4DF3-99CA-04D050BCF6AD@microsoft.com...
> > I have followed all the instructions to setup a linked server, yet when I
> try
> > to use the link I get the error:
> >
> > Exception occured in Microsoft OLE DB Provider for SQL Server, Login
> failed
> > for user '(null)'. Reason: Not associated with a trusted SQL Server
> > connection..
> > ADO Error Code: -2147217900
> >
> > I have run sp_addlinkedserver (successfully--using sp_linkedservers I can
> > see the server I created).
> >
> > I then ran sp_helplinkedsrvlogin and the linked server shows NULL for
> local
> > and remote logins with Is Self Mapping = 1. I couldn't tell if this is the
> > way it is supposed to be for Windows Authentication so I tried running
> > sp_addlinkedsrvlogin to create a login--but that doen't work either and
> the
> > SQL Server Knowledgebase is useless...
> >
> > Everything I've tried fails...
> >
> > Mike...
> >
> > PS: I can query the remote database with no problems if I connect to it
> > directly.
>
>
