Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Remote connection

7 posts in General Discussion Last posting was on 2012-01-23 17:31:28.0Z
green Posted on 2012-01-18 20:41:25.0Z
Sender: 5212.4f172d42.1804289383@sybase.com
From: Green
Newsgroups: sybase.public.ase.general
Subject: Remote connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f172e75.522d.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Jan 2012 12:41:25 -0800
X-Trace: forums-1-dub 1326919285 172.20.134.41 (18 Jan 2012 12:41:25 -0800)
X-Original-Trace: 18 Jan 2012 12:41:25 -0800, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30840
Article PK: 73729

Hi

I have a sybase server where I am able to establish remote
connection i.e remoteserver...sp_who without any remotelogin
setup. The entries exist on interfaces and as part of an
sp_addserver, but thats it. HOw is it that I am able to run
sp_who remotely without an explicit sp_addexternlogin setup?

Thanks


Rob V Posted on 2012-01-18 21:04:34.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
References: <4f172e75.522d.1681692777@sybase.com>
In-Reply-To: <4f172e75.522d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f1733e2$1@forums-1-dub>
Date: 18 Jan 2012 13:04:34 -0800
X-Trace: forums-1-dub 1326920674 10.22.241.152 (18 Jan 2012 13:04:34 -0800)
X-Original-Trace: 18 Jan 2012 13:04:34 -0800, vip152.sybase.com
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30841
Article PK: 73730


On 18-Jan-2012 21:41, Green wrote:
> Hi
>
> I have a sybase server where I am able to establish remote
> connection i.e remoteserver...sp_who without any remotelogin
> setup. The entries exist on interfaces and as part of an
> sp_addserver, but thats it. HOw is it that I am able to run
> sp_who remotely without an explicit sp_addexternlogin setup?
>
> Thanks

First, there are two ways to execute an RPC: with a remote login (a
so-called site-handler RPC), or with an external login (a CIS RPC).
These methods are completely different, so do not mix them up.

Remote logins are set up in the remore ASE server with
sp_addremotelogin; this defines which incomign RPCs are accepted and to
which logins these are mapped. The local server where you intiate the
RPC needs no special setup other than having the remote server added
with sp_addserver.

External logins are specified on the local server with
sp_addexternlogin, and these specify the login and password to use to
connect to the remote server. The remote server needs no special setup
for this.

From what you describe, you probably have a setup with remote logins.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


green Posted on 2012-01-18 21:32:13.0Z
Sender: 5212.4f172d42.1804289383@sybase.com
From: Green
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f173a5d.5360.1681692777@sybase.com>
References: <4f1733e2$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Jan 2012 13:32:13 -0800
X-Trace: forums-1-dub 1326922333 172.20.134.41 (18 Jan 2012 13:32:13 -0800)
X-Original-Trace: 18 Jan 2012 13:32:13 -0800, 172.20.134.41
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30842
Article PK: 73732


> On 18-Jan-2012 21:41, Green wrote:
> > Hi
> >
> > I have a sybase server where I am able to establish
> > remote connection i.e remoteserver...sp_who without any
> > remotelogin setup. The entries exist on interfaces and
> > as part of an sp_addserver, but thats it. HOw is it that
> > I am able to run sp_who remotely without an explicit
> sp_addexternlogin setup? >
> > Thanks
>
> First, there are two ways to execute an RPC: with a remote
> login (a so-called site-handler RPC), or with an external
> login (a CIS RPC). These methods are completely different,
> so do not mix them up.
>
> Remote logins are set up in the remore ASE server with
> sp_addremotelogin; this defines which incomign RPCs are
> accepted and to which logins these are mapped. The local
> server where you intiate the RPC needs no special setup
> other than having the remote server added with
> sp_addserver.
>
> External logins are specified on the local server with
> sp_addexternlogin, and these specify the login and
> password to use to connect to the remote server. The
> remote server needs no special setup for this.
>
> From what you describe, you probably have a setup with
> remote logins.
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

Thanks Rob. YEs found out it was a remotelogin. Have set it
up with trusted option. But still cannot run sp_who from the
other server. Any advise?


Rob V Posted on 2012-01-18 23:06:20.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
References: <4f1733e2$1@forums-1-dub> <4f173a5d.5360.1681692777@sybase.com>
In-Reply-To: <4f173a5d.5360.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f17506c$1@forums-1-dub>
Date: 18 Jan 2012 15:06:20 -0800
X-Trace: forums-1-dub 1326927980 10.22.241.152 (18 Jan 2012 15:06:20 -0800)
X-Original-Trace: 18 Jan 2012 15:06:20 -0800, vip152.sybase.com
Lines: 82
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30843
Article PK: 73736


On 18-Jan-2012 22:32, Green wrote:
>> On 18-Jan-2012 21:41, Green wrote:
>>> Hi
>>>
>>> I have a sybase server where I am able to establish
>>> remote connection i.e remoteserver...sp_who without any
>>> remotelogin setup. The entries exist on interfaces and
>>> as part of an sp_addserver, but thats it. HOw is it that
>>> I am able to run sp_who remotely without an explicit
>> sp_addexternlogin setup?>
>>> Thanks
>>
>> First, there are two ways to execute an RPC: with a remote
>> login (a so-called site-handler RPC), or with an external
>> login (a CIS RPC). These methods are completely different,
>> so do not mix them up.
>>
>> Remote logins are set up in the remore ASE server with
>> sp_addremotelogin; this defines which incomign RPCs are
>> accepted and to which logins these are mapped. The local
>> server where you intiate the RPC needs no special setup
>> other than having the remote server added with
>> sp_addserver.
>>
>> External logins are specified on the local server with
>> sp_addexternlogin, and these specify the login and
>> password to use to connect to the remote server. The
>> remote server needs no special setup for this.
>>
>> From what you describe, you probably have a setup with
>> remote logins.
>>
>> --
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Professional DBA for Sybase ASE, IQ, Replication
>> Server
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
>> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
>> "The Complete Sybase ASE Quick Reference Guide"
>> "The Complete Sybase Replication Server Quick Reference
>> Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>
> Thanks Rob. YEs found out it was a remotelogin. Have set it
> up with trusted option. But still cannot run sp_who from the
> other server. Any advise?

I'm not sure I understand the problem. If you want to run sp_who remote
in both servers, then each should be set up with either a remotelogin or
an externlogin.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


green Posted on 2012-01-23 17:19:30.0Z
Sender: 3326.4f1d9583.1804289383@sybase.com
From: Green
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f1d96a2.3361.1681692777@sybase.com>
References: <4f17506c$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Jan 2012 09:19:30 -0800
X-Trace: forums-1-dub 1327339170 172.20.134.41 (23 Jan 2012 09:19:30 -0800)
X-Original-Trace: 23 Jan 2012 09:19:30 -0800, 172.20.134.41
Lines: 96
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30856
Article PK: 73744


> On 18-Jan-2012 22:32, Green wrote:
> >> On 18-Jan-2012 21:41, Green wrote:
> >>> Hi
> >>>
> >>> I have a sybase server where I am able to establish
> >>> remote connection i.e remoteserver...sp_who without
> any >>> remotelogin setup. The entries exist on interfaces
> and >>> as part of an sp_addserver, but thats it. HOw is
> it that >>> I am able to run sp_who remotely without an
> explicit >> sp_addexternlogin setup?>
> >>> Thanks
> >>
> >> First, there are two ways to execute an RPC: with a
> remote >> login (a so-called site-handler RPC), or with
> an external >> login (a CIS RPC). These methods are
> completely different, >> so do not mix them up.
> >>
> >> Remote logins are set up in the remore ASE server with
> >> sp_addremotelogin; this defines which incomign RPCs are
> >> accepted and to which logins these are mapped. The
> local >> server where you intiate the RPC needs no
> special setup >> other than having the remote server added
> with >> sp_addserver.
> >>
> >> External logins are specified on the local server with
> >> sp_addexternlogin, and these specify the login and
> >> password to use to connect to the remote server. The
> >> remote server needs no special setup for this.
> >>
> >> From what you describe, you probably have a setup
> with >> remote logins.
> >>
> >> --
> >> HTH,
> >>
> >> Rob V.
> >>
> ----------------------------------------------------------
> >> ------- Rob Verschoor >>
> >> Certified Professional DBA for Sybase ASE, IQ,
> Replication >> Server
> >>
> >> Author of Sybase books (order online at
> >> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> >> ASE" "The Complete Sybase IQ Quick Reference Guide"
> (new!) >> "The Complete Sybase ASE Quick Reference Guide"
> >> "The Complete Sybase Replication Server Quick Reference
> >> Guide"
> >>
> >> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> >> @rob_verschoor Sypron B.V., The Netherlands | Chamber
> of >> Commerce 27138666
> >>
> ----------------------------------------------------------
> >> ------- >
> > Thanks Rob. YEs found out it was a remotelogin. Have set
> > it up with trusted option. But still cannot run sp_who
> > from the other server. Any advise?
>
>
> I'm not sure I understand the problem. If you want to run
> sp_who remote in both servers, then each should be set up
> with either a remotelogin or an externlogin.
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

On the remoteserver I find below entry
localservername ** mapped locally ** user
trusted

so I am executing from localserver exec
remoteserver...sp_who and not getting thing back. However in
another environment the same return find. I am not seeing
any remotelogins setup on the local server and assuming the
trusted option allows this to work. So why is the same not
working in the new environment?


Eisen Posted on 2012-01-21 01:18:08.0Z
Sender: 4ea3.4f1a1222.1804289383@sybase.com
From: Eisen
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f1a1250.4ead.1681692777@sybase.com>
References: <4f173a5d.5360.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Jan 2012 17:18:08 -0800
X-Trace: forums-1-dub 1327108688 172.20.134.41 (20 Jan 2012 17:18:08 -0800)
X-Original-Trace: 20 Jan 2012 17:18:08 -0800, 172.20.134.41
Lines: 67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30854
Article PK: 73743

Hi Green
Can you try "exec remoteserver.sybsystemprocs..sp_who"?
Thanks.

Best Regards
Eisen

> > On 18-Jan-2012 21:41, Green wrote:
> > > Hi
> > >
> > > I have a sybase server where I am able to establish
> > > remote connection i.e remoteserver...sp_who without
> > > any remotelogin setup. The entries exist on interfaces
> > > and as part of an sp_addserver, but thats it. HOw is
> > > it that I am able to run sp_who remotely without an
> > explicit sp_addexternlogin setup? >
> > > Thanks
> >
> > First, there are two ways to execute an RPC: with a
> > remote login (a so-called site-handler RPC), or with an
> > external login (a CIS RPC). These methods are completely
> > different, so do not mix them up.
> >
> > Remote logins are set up in the remore ASE server with
> > sp_addremotelogin; this defines which incomign RPCs are
> > accepted and to which logins these are mapped. The
> > local server where you intiate the RPC needs no special
> > setup other than having the remote server added with
> > sp_addserver.
> >
> > External logins are specified on the local server with
> > sp_addexternlogin, and these specify the login and
> > password to use to connect to the remote server. The
> > remote server needs no special setup for this.
> >
> > From what you describe, you probably have a setup with
> > remote logins.
> >
> > --
> > HTH,
> >
> > Rob V.
> >
> >
> ----------------------------------------------------------
> ------- Rob Verschoor >
> > Certified Professional DBA for Sybase ASE, IQ,
> > Replication Server
> >
> > Author of Sybase books (order online at
> > www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> > ASE" "The Complete Sybase IQ Quick Reference Guide"
> > (new!) "The Complete Sybase ASE Quick Reference Guide"
> > "The Complete Sybase Replication Server Quick Reference
> > Guide"
> >
> > rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> > @rob_verschoor Sypron B.V., The Netherlands | Chamber
> > of Commerce 27138666
> >
> >
> ----------------------------------------------------------
> -------
>
> Thanks Rob. YEs found out it was a remotelogin. Have set
> it up with trusted option. But still cannot run sp_who
> from the other server. Any advise?


green Posted on 2012-01-23 17:31:28.0Z
Sender: 33b6.4f1d9890.1804289383@sybase.com
From: Green
Newsgroups: sybase.public.ase.general
Subject: Re: Remote connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f1d9970.33da.1681692777@sybase.com>
References: <4f1a1250.4ead.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Jan 2012 09:31:28 -0800
X-Trace: forums-1-dub 1327339888 172.20.134.41 (23 Jan 2012 09:31:28 -0800)
X-Original-Trace: 23 Jan 2012 09:31:28 -0800, 172.20.134.41
Lines: 89
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30857
Article PK: 73748

Eisen

I still get a login failed error with below command
Login failed.
Msg 11206, Level 16, State 1
Server 'LOCAL_DS', Line 1
Unable to connect to server 'REMOTE_DS'.

On REMOTE_DS I have the following returned for
sp_helpremotelogin
server remote_user_name
local_user_name options
---------------------- ----------------------
---------------------- ----------------------------
LOCAL_DS ** mapped locally **
user1 trusted

> Hi Green
> Can you try "exec remoteserver.sybsystemprocs..sp_who"?
> Thanks.
>
> Best Regards
> Eisen
>
> > > On 18-Jan-2012 21:41, Green wrote:
> > > > Hi
> > > >
> > > > I have a sybase server where I am able to establish
> > > > remote connection i.e remoteserver...sp_who without
> > > > any remotelogin setup. The entries exist on
> > > > interfaces and as part of an sp_addserver, but thats
> > > > it. HOw is it that I am able to run sp_who remotely
> > > without an explicit sp_addexternlogin setup? >
> > > > Thanks
> > >
> > > First, there are two ways to execute an RPC: with a
> > > remote login (a so-called site-handler RPC), or with
> > > an external login (a CIS RPC). These methods are
> > > completely different, so do not mix them up.
> > >
> > > Remote logins are set up in the remore ASE server with
> > > sp_addremotelogin; this defines which incomign RPCs
> > > are accepted and to which logins these are mapped.
> > > The local server where you intiate the RPC needs no
> > > special setup other than having the remote server
> > > added with sp_addserver.
> > >
> > > External logins are specified on the local server with
> > > sp_addexternlogin, and these specify the login and
> > > password to use to connect to the remote server. The
> > > remote server needs no special setup for this.
> > >
> > > From what you describe, you probably have a setup
> > > with remote logins.
> > >
> > > --
> > > HTH,
> > >
> > > Rob V.
> > >
> > >
> >
> >
> ----------------------------------------------------------
> > > ------- Rob Verschoor > Certified Professional DBA for
> > > Sybase ASE, IQ, Replication Server
> > >
> > > Author of Sybase books (order online at
> > > www.sypron.nl/shop): "Tips, Tricks & Recipes for
> > > Sybase ASE" "The Complete Sybase IQ Quick Reference
> > > Guide" (new!) "The Complete Sybase ASE Quick Reference
> > > Guide" "The Complete Sybase Replication Server Quick
> > > Reference Guide"
> > >
> > > rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> > > @rob_verschoor Sypron B.V., The Netherlands |
> > > Chamber of Commerce 27138666
> > >
> > >
> >
> >
> ----------------------------------------------------------
> ------- >
> > Thanks Rob. YEs found out it was a remotelogin. Have set
> > it up with trusted option. But still cannot run sp_who
> > from the other server. Any advise?