• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

Proxy settings

Does anyone know how to check for proxy server settings in sybase. Let''s say my current Sybase server is A. And I want to know if the settings on this server are enabled to allow reference/updates/deletes to remote Sybase server B.

What are the commands or functions?

Pls note: I am NOT asking for how to add a proxy server, only to know if my current one has the settings enabled.

  • 3
  • 2
1 Solution
Unfortunately, it is not very straightforward as each table needs to be defined against remote server.

You can check serverwide configuration by sp_helpserver. It shows remote server definition. But, then you need to check individual tables by sp_help <table name> on the database proxy table definitions are located. That is the database you access to remote tables on server B.
4LearningAuthor Commented:
Thankyou Alpmoon.

What I get by sp_helpserver is the following columns:
name, network_name, class, status, id, cost

So if the name of my Sybase server is S1, then against S1, in the status column, I only see the word "local".
If S1 did have proxy server settings, what would be status column value?

If you don't see the other server in that list, it means that server is not configured to access from S1. You should see the other server with its name on S1, its actual network name (the name in interfaces file) and other options like below:

 name                                     network_name                                             class                              
         status                                                                                                                                                                                                                                                          id       cost            
 ---------------------------------------- -------------------------------------------------------- ------------------------------------
         --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------------
 XXXXXXX                                 XXXXXXX                                                 local                              
                                                                                                                                                                                                                                                                          0          0            
 SYB_BACKUP                               XXXXXXX_BS                                              NULL                                
         timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                            1       NULL            
 SYB_REMOTE                               SYB_REMOTE                                                 ASE_server                          
         timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                            2       NULL
4LearningAuthor Commented:
I do see the remote server S2, that I would like to access. And it does have value for status column as -
timeouts, net password encryption, writable , rpc security model A.

I also tried running a stored procedure on S2 from S1 as-

and it does give me the result from that server.

So looks like it is configured to remotely connect. But if I run the following from S1

connect to S2
use db2

I get connect permission denied.
It depends on which user is trying to do it and how remote users are mapped. I think you should go through "Managing Remote Servers" chapter in Admin guide to set it up.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now