Remote Server question

sql2k sp3


Ive always used Linked Servers and as such dont really know about Remote
Servers. Anyways, here is the deal.

Box1 -- Replication Publisher. Has a Remote Server defined for Box2, which
is a Subscriber to Box1.

So, Im trying to exec a proc on Box2 while logged on to Box1 while logged in
as SA. But I get the message:

Server: Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'BLA'because 'sa' is not defined as a remote
login at the server.

The SA password is the same on both these boxes, so while logged in as SA I:


 sp_addlinkedsrvlogin
  @rmtsrvname =  'cpdbovs01'
,  @useself =  'true'

but that doesnt make my problem go away. The really funny thing here is that
I googled it, saw that I posted the same question years ago, see that I got
it, but cant read the answer.

TIA, ChrisR

Is it possible that your remote server is set up to use Windows
Authentication only?  (Even though you can set the 'sa' password, that
doesn't imply you can actually login using that standard SQL login.)

--
*mike hodgson*
blog: http://sqlnerd.blogspot.com



ChrisR wrote:

>sql2k sp3
>
>
>Ive always used Linked Servers and as such dont really know about Remote
>Servers. Anyways, here is the deal.
>
>Box1 -- Replication Publisher. Has a Remote Server defined for Box2, which
>is a Subscriber to Box1.
>
>So, Im trying to exec a proc on Box2 while logged on to Box1 while logged i
n
>as SA. But I get the message:
>
>Server: Msg 18483, Level 14, State 1, Line 1
>Could not connect to server 'BLA'because 'sa' is not defined as a remote
>login at the server.
>
>The SA password is the same on both these boxes, so while logged in as SA I
:
>
>
> sp_addlinkedsrvlogin
  @rmtsrvname =  'cpdbovs01'
>     ,  @useself =  'true'
>
>but that doesnt make my problem go away. The really funny thing here is tha
t
>I googled it, saw that I posted the same question years ago, see that I got
>it, but cant read the answer.
>
>TIA, ChrisR
>
>
>
>
>
>

Thanks Mike, but no thats not the case.
"Mike Hodgson" <mike.hodgson@mallesons.nospam.com> wrote in message news:O$v
QwAdrFHA.908@tk2msftngp13.phx.gbl...
Is it possible that your remote server is set up to use Windows Authenticati
on only?  (Even though you can set the 'sa' password, that doesn't imply you
 can actually login using that standard SQL login.)

--
mike hodgson
blog: http://sqlnerd.blogspot.com 



ChrisR wrote: 
sql2k sp3


Ive always used Linked Servers and as such dont really know about Remote 
Servers. Anyways, here is the deal.

Box1 -- Replication Publisher. Has a Remote Server defined for Box2, which 
is a Subscriber to Box1.

So, Im trying to exec a proc on Box2 while logged on to Box1 while logged in
 
as SA. But I get the message:

Server: Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'BLA'because 'sa' is not defined as a remote 
login at the server.

The SA password is the same on both these boxes, so while logged in as SA I:


 sp_addlinkedsrvlogin
  @rmtsrvname =  'cpdbovs01'
,  @useself =  'true'

but that doesnt make my problem go away. The really funny thing here is that
 
I googled it, saw that I posted the same question years ago, see that I got 
it, but cant read the answer.

TIA, ChrisR