Re: 'No login mapping' error message
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 12/08/04
- Next message: Sean: "Re: Config SQL Server to listen on a single IP address, localhost"
- Previous message: Mike: "Changing Sql7 TCP Port"
- In reply to: Loic: "'No login mapping' error message"
- Next in thread: loic_nospam_at_yahoo.com: "Re: 'No login mapping' error message"
- Reply: loic_nospam_at_yahoo.com: "Re: 'No login mapping' error message"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 8 Dec 2004 16:13:54 -0500
Loic,
Thinking about this, I note the comment: I have assigned a remote user and
password to my local windows account.
Are the two servers and the login (yours and remote) all on the same domain?
If not, you may not be getting what you expect.
RLF
"Loic" <loic_nospam@yahoo.com> wrote in message
news:d4a964bf.0412080201.3195a471@posting.google.com...
> Thanks for your reply Russell,
>
> To answer your question, @useself is set to 'false'.
>
> In fact, with the following script, I am telling it to ignore the local
user name.
>
> Exec sp_addlinkedsrvlogin @rmtsrvname='rmtsqlserver',
> @useself='false', @rmtuser='rmtuser',@rmtpassword='rmtpassword'
>
> Thanks
>
> Loic
- Next message: Sean: "Re: Config SQL Server to listen on a single IP address, localhost"
- Previous message: Mike: "Changing Sql7 TCP Port"
- In reply to: Loic: "'No login mapping' error message"
- Next in thread: loic_nospam_at_yahoo.com: "Re: 'No login mapping' error message"
- Reply: loic_nospam_at_yahoo.com: "Re: 'No login mapping' error message"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|