Re: Linked Server - Invalid user '\'

From: jimmers (jimmers@yandex.ru)
Date: 06/13/02 

From: "jimmers" <jimmers@yandex.ru>
Date: Thu, 13 Jun 2002 01:13:38 -0700

Sorry, how did You set 'Windows Authentication'?

Cheers

"Shamim" <Shamim.Abdul@railamerica.com> wrote in message
news:uWOkEskECHA.1360@tkmsftngp05...
> I already set-up linked server between two servers and its working fine ,
if
> logged in as 'sa' but not under NT account.
> I executed sp_addlinkedservlogin, but still the same error " Invalid user
> '\' ".
>
> Thanks for your reply..
>
> Sh
>
>
> "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
> news:O709MGkECHA.1964@tkmsftngp03...
> > You need to add a login mapping
> > This can be done via EM or using stored procedure
> > sp_addlinkedsrvlogin . See BOL for details
> > Registering servers in EM is completely different
> > from configuring linked servers so just because you
> > have registered a server does not mean its available
> > as a linked server
> >
> > HTH
> > Jasper Smith
> >
> > "Shamim" <Shamim.Abdul@railamerica.com> wrote in message
> > news:O5Eb8GjECHA.1288@tkmsftngp03...
> > > HI All,
> > >
> > > SQL SERVER 7.0
> > >
> > > I set-up linked server between 2 servers , say A and B.
> > > In Enterprise manager i registered server A under 'Windows NT
> > > Authentication' and in a stored procedure tried selecting from Server
B
> > but
> > > failing
> > > with an error message " Invalid user '\' ". Later i deleted server A
> > > registration and re-registered using 'sa' and this time it worked.
> > >
> > > With NT Authentication i tried
> > >
> > > SP_ADDLINKEDSrvlogin 'B'
> > > sp_serveroption 'B', 'data access', true
> > > sp_serveroption 'B', 'collation compatible', 'true'
> > >
> > > But it keep failing with the same error message " Invalid User '\' "
> > >
> > > Any thoughts/ideas will be highly appreciated.
> > >
> > >
> > > Thanks
> > > Shamim
> > >
> > >
> >
> >
>
>